Not creating an empty file when zero rows returned

• rcnelsonmba

  SSC Eights!

  Points: 813

  More actions

  December 13, 2004 at 12:17 pm

  #60272

  SQL Server 2000 DTS:  Want to do one of 2 things:  1) not produce a destination file at all if there are zero rows qualified out of the source query, or 2) delete the file after it is produced IF it's an empty file.  Any ideas/solutions are appreciated.

• john-132685

  SSCertifiable

  Points: 6134

  More actions

  December 13, 2004 at 3:17 pm

  #533657

  You can always do the crude and some would say klugy thing of a execsql step that says:

  IF NOT EXISTS( select 1 from table where condition) RAISERROR...

  and use the success path from that DTS step to the export routine.

  As for me, I tend to do the export inside a SQL proc and wrap it with that condition. (using xp_cmdshell to BCP the data)