Prevent SSIS for creating an empty csv file at destination

Question

I created a SSIS to export to a csv file I don't wan't my SSIS to create an empty file if there is no data.

How can I achieve this ?

Thanks,

Server

Oh man I read this question wrong at first, haha. – Barbuto

whats wrong on this – Server

Nothing, just skimming I saw the name of a terrorist group. – Barbuto

Answer 1

Are you suggesting that when your project will create the CSV if there are no rows?

If that is the case - keep a row count.

If row count = 0 at the end the delete the file.

Roadway

Yes that is the case.. But at what step i need to delete file and how. – Server

When would you expect to delete the file? Surely at the stage where no rows could be written to it? Use the File System Task – Roadway

But i want to delete only empty files right. How i can mention condition at File System Task. – Server