CODEWITHSUNDEEP
excelvisual-studiossis
Turpan
Turpan

Reputation: 535

Cannot connect to Excel SSIS

I'm trying to create a data flow task which brings data from Excel File to SQL table. I'm doing it in SQL Server Data Tools for Visual Studio 2012 as an SSIS package. However, when I run the task I receive below error:

[Excel Source [52]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC0209303. There may be error messages posted before this with more information on why the AcquireConnection method call failed.

Complete Error message:

SSIS package "C:\Users\adm.turpan\Documents\Visual Studio 2012\Projects\Integration Services Project1\Integration Services Project1\project.dtsx" starting. Information: 0x4004300A at Excel as source, SSIS.Pipeline: Validation phase is beginning. Error: 0xC020801C at Excel as source, Excel Source [52]: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC0209303. There may be error messages posted before this with more information on why the AcquireConnection method call failed. Error: 0xC0047017 at Excel as source, SSIS.Pipeline: Excel Source failed validation and returned error code 0xC020801C. Error: 0xC004700C at Excel as source, SSIS.Pipeline: One or more component failed validation. Error: 0xC0024107 at Excel as source: There were errors during task validation. SSIS package "C:\Users\adm.turpan\Documents\Visual Studio 2012\Projects\Integration Services Project1\Integration Services Project1\project.dtsx" finished: Success.

Upvotes: 11

Views: 45105

Answers (2)

M.Pat
M.Pat

Reputation: 11

Sometimes when the file is open, it creates a temp/hidden file in the same location and it is only visible to the one who opened it.

So place a breakpoint right before the load and check the value for "FileName" which is being passed. The temp/hidden files would be in thumb.db for Excel and different for different file formats.

Upvotes: 1

Turpan
Turpan

Reputation: 535

mehtat_90's comment was right; you need to set run64BitRuntime to False:

There can be several reason for this error and only after looking at the complete error message we will know what's exactly wrong. For time being I would recommend you to try change run64BitRuntime as False and set Delay validation as True

Right-click your project, and select Properties, then Configuration Properties, then Debugging: enter image description here

Upvotes: 18

Related Questions