all groups > sql server dts > october 2004 >
You're in the

sql server dts

group:

Execute Package Task - Workflow



Execute Package Task - Workflow Ian Tanner
10/21/2004 7:59:25 AM
sql server dts: 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?

Re: Execute Package Task - Workflow Darren Green
10/21/2004 6:03:11 PM
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

[quoted text, click to view]

AddThis Social Bookmark Button