SQL Server Performance Forum – Threads Archive
Transformation Tast zero recordHi, 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 inhttp://www.sqldts.com
I will update once found correct reference. Satya SKJ
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.