CODEWITHSUNDEEP
ssis
N.Dinesh.Reddy
N.Dinesh.Reddy

Reputation: 632

Force Execution Result IN SSIS

Can some one explain me what is use of Force execution Results in ssis Package Properties.I have not used this property even once.

Upvotes: 0

Views: 5837

Answers (1)

Shiva
Shiva

Reputation: 20955

It's mostly used to fake the results of a task or container and tell SSIS / the execution engine / caller what the status is, instead of the actual status of a task or container execution.

See Faking success in SSIS for a clear detailed explanation.

Also from SQL Server Books On Line.

You can use the ForceExecutionResult property on a task or container to test the use of checkpoints in a package. By setting ForceExecutionResult of the task or container to Failure, you can imitate real-time failure. When you rerun the package, failed tasks and containers will be rerun.

Upvotes: 4

Related Questions