I am using a SQL stored procedure to select data and then output the results to a CSV file.

However if the stored procedure returns no rows, I would not like a CSV file to be created. I only want a CSV file created if there is data in the file.

I find that the DTS package - using the Data Transformation task produces a file regardless of whether the file has data or not.

Does anyone know how to stop the production of a CSV file if there are no rows returned by the SQL query?

Regards

Phillip

you have to add a step beforehand where you check the count of the sp
if the count = 0 end
if it's > 0 produce the file
You can store this in a global variable

“I sense many useless updates in you... Useless updates lead to fragmentation... Fragmentation leads to downtime...Downtime leads to suffering..Fragmentation is the path to the darkside.. DBCC INDEXDEFRAG and DBCC DBREINDEX are the force...May the force be with you" -- http://sqlservercode.blogspot.com/