SQL Server Performance Forum – Threads Archive

Transformation Tast zero record

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.

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.

]]>