CODEWITHSUNDEEP
sql-serverexcelforeachssis
J.S.Orris
J.S.Orris

Reputation: 4831

Foreach Loop Container ERROR: [Excel Source [2]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER........"

I have a Foreach Loop Container looping through a directory and importing ExcelSource data to SQL Server. The connection is fine until I add the expression to the ExcelSource Connection Property. I followed all the steps in the tutorial. Why do I keep getting the following error?:

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

Upvotes: 0

Views: 3525

Answers (1)

Sergio Espallargas
Sergio Espallargas

Reputation: 211

You would have to set DelayValidation to true on both Foreach Loop Container and Excel Connection Manager for this to work.

Upvotes: 1

Related Questions