Home > SQL Server > Error reading Excel in SSIS package

Error reading Excel in SSIS package

2013/05/14

The task was simple: import from an Excel file some data in a SQL Server table.

But the first task of reading the Excel file was already in error:


And in the SSIS solution Progress tab there was the error:

“[Excel Source [26]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.

The AcquireConnection method call to the connection manager “Excel Connection Manager” failed with error code 0xC0209303.”

This is the second time that i don’t remember the simple solution… even if the last error message is a bright hint:

“The requested OLE DB provider Microsoft.Jet.OLEDB.4.0 is not registered. If the 64-bit driver is not installed, run the package in 32-bit mode.”

In the SSIS project right clic on solution name , Properties and here deactivate the 64bit debugging:


Advertisements
Categories: SQL Server
%d bloggers like this: