Importing Excel data with SSIS

Submitted by Bevan on Fri, 04/02/2011 - 11:32

If you're crazy enough(*) to be using SSIS to import information from an Excel workbook into a database, you may get an error like this:

Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.
The AcquireConnection method call to the connection manager "Time Series XLSX" failed with error code 0xC00F9304.

The solution is to go into project properties, select the "Debugging" page and set Run64BitRuntime to false.

[img_assist|nid=468|title=|desc=|link=popup|align=center|width=512|height=336]

() I'm not normally this crazy, but when a job needs to be done, someone has to do it. *Sigh.

Blog Tags: 
Tips

Comments

Submitted by Mike (not verified) on Mon, 05/03/2012 - 06:57.

Importing data from excel using SSIS is a waste of time

Eventually you realise that there is nothing you can do about it

http://www.etl-tools.com/imex1.html

Our software Avanced ETL Processor works as expected with excel files

http://www.etl-tools.com/etl-tools/advanced-etl-processor-enterprise/ove...

Mike
dbSL