When there are no rows in the ADO Net source is there a way of suppressing the creation of the Flat File?

Feb 3, 2012 at 5:59 PM

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?