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.
ForceExecutionResult
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
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.
ForceExecutionResult
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:
Post a Comment