Monday, April 8, 2013

SSIS Package Error while exporting data to EXCEL


I have been told to create a SSIS package which populate the data in Excel and send to the requested users.
I have succeded creating every task in the process. But, while executing the pacage I have got below error. So after little bit investigation I used the below solution and made it work. It may helpful to one of you.

If you have some other issue as you can see many, Please send me the issue I will try to make it work for you.

Problem :

Error: 0xC00F9304 at SQLToExcel, Connection manager "Excel Connection Manager": SSIS Error Code DTS_E_OLEDB_EXCEL_NOT_SUPPORTED: The Excel Connection Manager is not supported in the 64-bit version of SSIS, as no OLE DB provider is available.
Error: 0xC020801C at Data Flow Task, ReportExcel [16]: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.  The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC00F9304.  There may be error messages posted before this with more information on why the AcquireConnection method call failed.
Error: 0xC0047017 at Data Flow Task, SSIS.Pipeline: component "ReportExcel" (16) failed validation and returned error code 0xC020801C.
Error: 0xC004700C at Data Flow Task, SSIS.Pipeline: One or more component failed validation.
Error: 0xC0024107 at Data Flow Task: There were errors during task validation.
SSIS package "SQLToExcel.dtsx" finished: Failure.

Solution :

The below solution may solve your problem.

Right click on Project
Select Debugging
In Debug Options
Run64BitRuntime make it to False.

No comments:

Post a Comment