Hi
I ran into an issue in SSIS package running from SQL Job Agent Schedule. The package loads multiple .txt files simultaneously and i am using the for each loop container. The ssis uses the expression to the filename to a variable and then to the connection string. I am getting the error randomly "failed the pre-execute phase and returned error code 0x8007000E". Can some please provide the direction to troubleshoot or seen this error before?
Thanks
Shuaib