For each loop error handling
I have ForEach loop in SSIS package , the foreach loop is get feed by records in Table A Table A ID 1 2 3.. etc… And IN For each LOOP there are two child packages.. I would like to set up the error handling , For example, if the ID 1 in Table A got fail during the first child package then go to ID 2 and start it over from the First child package.. and so on.. without stopping the whole package How can I do this? How can I go to next record in Table and start over the for each loop from the beginning ( getting record from Table A and go thru the loop_ again if the first child package fail with that record?.. the failed ID ( i.e ID 1 ) will be removed from Table A as soon as there is an error while going thru the first package…
September 29th, 2011 1:31am

I am thinking you can use precedence constraint set to run package 2 on failure. In addition set the FailPackageOnFailure property to not to fail the parent package for the package 1.Arthur My Blog
Free Windows Admin Tool Kit Click here and download it now
September 29th, 2011 2:03am

Additionally, investigate the "Propagate" property of the OnError event handler...setting it to "False" prevents errors from bubbling up and causing the container above the failed one and/or the whole package to fail. Hope that this helps...Chris
September 30th, 2011 2:57pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics