Are there some errors which are not trapped by the Failure workflow on DTS ?
I set up a package to load data from one system to another. It failed
because the file was in use. The following step of the package was set to
execute on the Failure of that step but it did not run. I tried changing the
workflow to Completion and it still did not run.

One of two possibilities:

1) You may have the package option "Fail package on first error" checked.
Right-click on the designer surface, choose Package Properties and click on
the Logging tab. Make sure the option if off.
2) You may have the step property "Fail package on step failure" checked. To
find out, right-click the task, choose Workflow, then choose Workflow
Properties, and click the Options tab. You need to make sure the option is
turned off.

Charles Kangai, MCT, MCDBA


"rmcompute" wrote:

Thank you.

"Charles Kangai" wrote: