Cannot connect to Excel SSIS

0 votes

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.

Would you be able help please? 

Sep 23 in Others by Kithuzzz
• 20,660 points
383 views

1 answer to this question.

0 votes

You need to set run64BitRuntime to False. See below where to find it:

Project -> Properties -> enter image description here

answered Sep 24 by narikkadan
• 37,660 points

Related Questions In Others

0 votes
0 answers

unable to connect to internet in edureka VM

i am unable to connect to internet ...READ MORE

Jun 7, 2019 in Others by Ashok
• 120 points
290 views
0 votes
1 answer

How to connect mobile camera to Flutter App?

Hi@akhtar, You need to install the plugin to ...READ MORE

answered Sep 14, 2020 in Others by MD
• 95,380 points
261 views
0 votes
1 answer
0 votes
1 answer

nodetool: Failed to connect to '127.0.0.1:7199' - ConnectException: 'Connection refused (Connection refused)'.

Hi, @Manjima, what do your system logs say? READ MORE

answered Dec 4, 2020 in Others by Rajiv
• 8,910 points
401 views
+6 votes
5 answers

can't remove SSIS variables using remove method on PowerShell

you're missing the additional $environment.Alter() after your ...READ MORE

answered Mar 27, 2018 in DevOps & Agile by ajs3033
• 7,300 points
1,088 views
0 votes
1 answer

Retrieve epay.info Balance with VBA and Excel

This code should log you in, provided ...READ MORE

answered Sep 5, 2018 in Blockchain by digger
• 26,720 points
452 views
0 votes
1 answer

ImportError: openpyxl is required for loading excel format files

Forget the PsychoPy complications for the time ...READ MORE

answered Oct 3, 2018 in Python by Priyaj
• 58,100 points
402 views
0 votes
1 answer

In Blue Prism how to split excel column data into TWO columns

This is how I am doing it. Dim ...READ MORE

answered Oct 15, 2018 in RPA by Priyaj
• 58,100 points
3,382 views
0 votes
1 answer
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP