We have a package that loads the data from several excel files into database in a forloop.
Everything works files until the package hits the bad file.
My goal is to continue the loop to process the rest of the files by skipping the bad file and error. In each task OnError I am creating custom error message to send an error/ sucess summary email out at end of the process.
How can force the for loop to continue when there is an error?
Is there any way to reset the errors?
Thanks
R
The behavior is mostly controlled by three properties: MaxErrorCount, FailPackageOnFailure and FailParentOnFailure. You can increas error count and set "fail" properties to false to make package continue inspite of an error.
No comments:
Post a Comment