I moved a perfectly fine working package to another laptop and it fail to run run now. (I did this before to another laptop and everything worked fine then)
The package fails after running a foreach loop with a control flow. I want to load several Excel files into a database.
I'm getting this error message:
[Read CP XL File [14]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed. [SSIS.Pipeline] Error: Read CP XL File failed validation and returned error code 0xC020801C.
Sidenote, there is no error message posted before.
I tried to:
DelayValidation
on both True and False. Does anyone now a solution?
User contributions licensed under CC BY-SA 3.0