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

2
votes

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.

1
sqlsql-serverssis
Check the destination location exists, also check if you have access to location, and put full error message here, SSIS error messages are pretty misleading at times. - M.Ali
Expanding on @M.Ali's comment above: To succeed in this task, the account running the process must have at least read privileges on the folder containing the Excel spreadsheet, and on the spreadsheet itself. Also, the path to the SS needs to be correct from the perspective of the SQL Server - if the spreadsheet is on your local C:\Documents folder but your SQL Server is on another machine, the SQL Server needs access through a path from the SQL Server - something like \\MyMachine\C$\Documents\MyExcel.xlsx or \\MyMachine\DocShare\MyExcel.xlsx - Laughing Vergil
Does the error occur on the development machine or on the server? - Wolfgang Kais
I've also noticed on my excel source 'Advanced editor' that the order of columns mapping does not match the order on the excel file, would that cause issue ? - ivric

1 Answers

0
votes

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