Tuesday, December 22, 2009

SSIS handling errors in control flow

To ensure that errors don't cause the package to stop, but all errors are reported back to parent containers, set the following:

FailParentOnFailure = True
MaximumErrorCount = 99999 (an "infinite" value)

1 comment:

Anonymous said...
This comment has been removed by a blog administrator.