I executed a DTS that has a list of "Execute Package Task"
to execute other DTS in sequence. Checking first if
previous package has finished successfully.

I do it using workflow.

But it does not work when one of the called DTS fails in
an "Execute SQL Task".

How can I solve this problem?

Thank you!

For the execute package task to fail when a child package task fails you
need to set fail on first error in the child package. See the Package
Properties dialog.


--
Darren Green
http://www.sqldts.com

"Ian Tanner" <anonymous (AT) discussions (DOT) microsoft.com> wrote