Excel Connection Manager

I find myself needing to import files from time to time and usually use SSIS to import the data–normally to a temp table.  I did so the other day and got this error.

SSIS package “MyTest.dtsx” starting.
Information: 0x4004300A at 2008 10K, SSIS.Pipeline: Validation phase is beginning.
Error: 0xC00F9304 at MyTest, 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 2008 10K, Excel Source [1]: 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 2008 10K, SSIS.Pipeline: component “Excel Source” (1) failed validation and returned error code 0xC020801C.
Error: 0xC004700C at 2008 10K, SSIS.Pipeline: One or more component failed validation.
Error: 0xC0024107 at 2008 10K: There were errors during task validation.SSIS package “MyTest.dtsx” finished: Failure.

I normally just run the package in Visual Studio, so I changed the 64 bit option of the package property and that allowed me to execute the package successfully.  Should you need to save the package and run it in a scheduled job, you will need to make this change elsewhere as noted here.

This setting can be found by clicking on Properties/[Package Name] properties . . . Where [Package Name] is the name of the package you are working with.

SSISPropertyConfig_64Bit

4 thoughts on “Excel Connection Manager

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s