August 29, 2017 at 4:07 pm
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
August 30, 2017 at 12:48 pm
You can find a list of things to try addressing the error in the following link:
SSIS package fails with out of memory errors
You can find some additional information on buffer management and monitoring in the follow article - check the end of the Best Practice #7 for monitoring what is going on in that area:
SQL Server Integration Services SSIS Performance Best Practices
Sue
August 30, 2017 at 2:14 pm
Thank you. Will take a look at it.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply