Microsoft SQL Server forum - Conditional execution of DTS package task

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Conditional execution of DTS package task

Scouser

2006-01-26, 4:57 pm

I've searched everywhere for this but can't find the answer

I want to run a DTS package that simply executes a SQL statement to get
a count of rows in a table, if the resulting number is greater than
zero I want to execute another step in the same package, else just
quit.

I don't to pass global vars from one package to another

How can I do this?

Any help would be great

2006-01-26, 4:57 pm

Hi Scouser,

I've got a suggestion: Create a stored proc that does the count of the
records and then execute the DTS from the procedure, if the condition
is true.
Look at this message if you want to see how to execute the DTS-Package
from a stored procedure:
http://groups.google.de/group/borla...%2F2ca55

aa1eaff59b9%2F2bd625
80101f38fe%3Flnk%3Ds
t%26q%3DDarren+Green
+200006013%26rnum%3D
1%26hl%3Dde%26#doc_2
bd62580101f38fe

Michael
www.zankl-it.de

Sponsored Links