1. nilayinc New Member

   Hi,
   
   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,
   Nilay.

   nilayinc, Jan 14, 2004

   #2
2. satya Moderator

   I think its possible, sometime ago seen similar script inhttp://www.sqldts.com
   I will update once found correct reference.
   
   Satya SKJ
   Moderator
   http://www.SQL-Server-Performance.Com/forum
   This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

   satya, Jan 14, 2004

   #2

Please click 'Forgot Your Password' to reset your password if this is your first time using the new forums.

Your name or email address:

Do you already have an account?

Forgot your password?

• No, create an account now.
• Yes, my password is:

Stay logged in