SQL Server Integration Services - ForceExecutionResult

By right-clicking on any tasks in SSIS,We can find under the property - ForceExecutionResult

In the below example ,I am using Execute SQL Task and creating a table.

I have set the ForceExecutionResult to Failure,which actually shows the task as failed but the table will be created in the database.


A value that specifies the forced result of running the package or container. The values are None, Success, Failure, and Completion. The default value for this property is None.

Reference - http://msdn.microsoft.com/en-us/library/ms137728.aspx

No comments: