Conditional execution of DTS package task

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

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...r />
d%2F2ca55
 aa1eaff59b9%2F2bd625
 80101f38fe%3Flnk%3Ds
 t%26q%3DDarren+Green
+200006013%26rnu
 m%3D1%26hl%3Dde%26#d
oc_2bd62580101f38fe

Michael
www.zankl-it.de