Resolve COleException when performing Export to Excel in Design Studio under Windows 7 (64-bit) in Sagent


Customer is getting COleException when performing export to excel operation in Design Studio.

Steps to replicate:
Create a Excel sink plan having two inputs and two output excels.
Execute the plan and from Tools, try to export to excel.

Customer has reported that excel plan works fine on Windows 7 (32-bit) with MS Office 2010(32-bit). But with same plan on Windows 7(64-bit) with MS Office 2010(64-bit), COleException is returned in Design Studio.
Moreover the exported xlsx file is too small compared to the output being expected.


Customer plan analysed and found that the issue is with second input source due to which exception is thrown.

Further analysis shown that certain values in input data is causing the issue.

When second input is removed and used a sample input instead, the plan executed successfully without any exception or error. 



UPDATED: April 20, 2017

Verify and correct input data used in second input source, save and execute the plan.


Environment Details

Product Feature: Excel Sink
Operating System: Windows 7 64bit
Database: SQL Server 2008



  • No Downloads