DTS Package designer add success criteria

I'm using the DTS Package designer to export data to a text file.
But I only want to export/create a file, if there is data to export. ie
if (select count(*) from xxx ) > 0 do export.

How can I do this?

Hello paulhux174 (AT) hotmail (DOT) com,


You do this

In an ExecuteSQL task you count the rows in the table
You assign this to a variable using the Parameters button
On Success you move to a script task which tests the value of the variable

If the value > X you enable a path to the datapump task
If not then you disable that path.

You can find examples on our site of doing these things

www.SQLDTS.com


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com