I set up a workflow in DTS to execute an SQL task when a previous SQL task
fails which worked successfully. I then set up an SQL task to run when a
previous package fails. The package loads data from Access to SQL Server. I
removed the table it loads from Access to get it to fail, however the SQL
task which is supposed to run did not run. Does the workflow failure only
apply to SQL tasks ? Is there something else that needs to be done to get it
to work when a package fails ?

I reviewed the setup and it was incorrect. The process is now working
correctly.

"rmcompute" wrote: