SSIS - 2005 - Log and execute package in loop

Question

Hello

I have a package that extracts data from 10 databases that is same in structure and i do this in for each loop by changing the connection on every iteration, but if there is an error like request timeout error or anyother error the package stops but i would like to log the error in text file and go to next database and continue execution till the end of loop. I need to know how i can make the package continue to execute after logging the error.

Harris

Answer 1

Check if this link is helpful
http://agilebi.com/cs/blogs/jwelch/archive/2008/06/29/continuing-a-loop-after-an-error.aspx

---

Nitesh Rai- Please mark the post as answered if it answers your question

Answer 2

as mention in nitesh's link, you need to set the MaximumErrorCount property of the package to 0

---

Let us TRY this | Don’t forget to mark the post(s) that answered your question