Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Cannot connect to Excel SSIS

Tags:

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.

Would you be able help please?

Thank you

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.

like image 301
Turpan Avatar asked Sep 08 '16 14:09

Turpan


People also ask

How do I link SSIS to Excel?

On the SSIS menu, select New connection. In the Add SSIS Connection Manager dialog box, select EXCEL and then Add. Create the connection manager at the same time that you configure the Excel Source or the Excel Destination on the Connection manager page of the Excel Source Editor or of the Excel Destination Editor.

What are the problems issues with Excel source in SSIS?

Our source file has mixed data types some account codes have any numbers and some have characters as well. We have more cells with numbers only so Excel ODBC/Jet assumes the field type is numeric and shows the rest of it as nulls. Setting IMEX=1 tells the driver to use the Import mode.


1 Answers

mehtat_90 was right. you need to set run64BitRuntime to False. See below where to find it:

Project -> Properities -> enter image description here

like image 60
Turpan Avatar answered Sep 27 '22 19:09

Turpan