Hi
I have a DTS task (Task N) which has 4 precedence tasks,
only one of which can ever execute. It seems as if DTS
assumes an 'AND' operator between the tasks, and there is
no 'OR' option, so Task N cannot ever execute. I have
therefore split the package in half, and added Task N and
all of its successors to the new package, with the plan to
call the second package from each of the 4 precedence
tasks. I've created an 'Execute SQL Task' and am using the
syntax below:
EXEC master..xp_cmdshell 'dtsrun /S ServerName /E /N
CalledPackageName', NOOUTPUT
but the called package fails to run. I know there are no
errors with either package, as they both run OK if I call
them directly from DTS designer (SQL 7.0). Both packages
are large, so I don't want to Task N and all of its
successors to each of the four outcomes, although I have
added them to one of the outcomes as a test, and this runs
fine.
I hope this all makes sense? Thanks for reading it through!
Any help would be greatly appreciated.
Peter