I have created an SSIS data flow task which uses a ADO Net source and a Flat File destination which works fine. It is creating approx 30 files, each using a different query. If there are rows returned then the file is created, but when there are no rows in the ADO Net source is there a way of suppressing the creation of the Flat File?
data flow task file
The short answer is that you need to delete it in the control flow.
Try this link
http://www.sqlservercentral.com/blogs/timmitchell/2009/9/30/eliminating-empty-output-files-in-ssis/
http://social.msdn.microsoft.com/Forums/en/sqlintegrationservices/thread/dcd16661-79d2-4607-a605-acae753b2438
Thanks for your sharing
Managed Windows Shared Hosting by OrcsWeb