Transformation Tast zero record | SQL Server Performance Forums

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,
I think its possible, sometime ago seen similar script in
I will update once found correct reference. Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.