[Excel Source [37]] Error:SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER

▲
2
▼

Hi Im facing the below error on my ssis package.

[Excel Source [37]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Excel Connection Manager 2" failed with error code 0xC0202009.

I even switch the Run64BitRuntime -from True to False - turning off the 64Bit for the solution but it didn't solve the issue.

My package is failing on the excel source. Any help is appreciated.

sql
sql-server
ssis
asked on Stack Overflow Jul 16, 2018 by ivric • edited Jul 17, 2018 by ivric

1 Answer

▲
0
▼

I had the same problem, and I just to turned out Run64BitRuntime to false

answered on Stack Overflow May 23, 2020 by Douglas

User contributions licensed under CC BY-SA 3.0