SQL Server Performance

Transformation Tast zero record

Discussion in 'SQL Server DTS-Related Questions' started by nilayinc, Jan 14, 2004.

  1. nilayinc New Member


    I have DTS which takes data from table and generates file. And for this I am using Transformation task. I want to create file only if there is data in the table.. But currently file is getting created even if number of records are zero. Is there a way in DTS to check for zero record count and stop if it is?

    Thanks and Regards,
  2. satya Moderator

Share This Page