Hi

I have a For Each Loop that iterates over the nodes in an XML document. The
For Each Loop contains a Sequence Container that wraps all the actual
processing elements (data flows and Tasks). I need to set up the Loop so that
even if a row fails processing, either in the Tasks or Data Flow, it is
skipped and processing continues to the next row.

I have set the Transaction Option to Required on the Sequence Container.
This at least ensures that all the rows processed till the point the failure
occurs are not being rolled back. But the package fails after the first row
in error.

Can anyone tell me how to get this done. I am relatively new to SSIS and ETL
in general.

Thanks in advance
Vikas