Tuesday, July 5, 2011

Failure is not my option.. Control SSIS flow success or failure options..

How to control the success and failure of the package and execute it successfully?  Sometimes the requirement is to continue the execution even if an error has raised, might be a package that has nondependent tasks.

There are 3 ways to do that…

1- Setting up ‘MaximumErrorCount’ property of the container as ‘0’ instead of the default ‘1’.
2- Setting up ‘ForceExecutionResult’ property to ‘success’ for the task properties instead of the default ‘None’.

3- In tasks sequence, we can set ‘On Completion’ precedence constraint instead of ‘Success’.

Hope that helps.