I'm exporting a table output to a CSV file. I'm doing it using SSIS package which has OLE DB Source and Flat File Destination. I'm getting the following errors: [Flat File Destination [2]] Error: ...

I have the below within the Data-flow area. The problem I'm experiencing is that even if the result is 0, it is still creating the file. Can anyone see what I'm doing wrong here?