SSIS to create a text file only when it need to

ugh3012 · January 26, 2016, 1:42am

I am trying to set SSIS to create a text file only if there are rows in the result set. Is that possible? I don't see expression control. Basically, if there is no result, skip that step and move on to the next control. If there is result, then create the text file and move on to the next control.

gbritton · January 26, 2016, 2:25pm

to create a text file, you'll need a Data Flow. The DataFlow task supports Expressions. You can set the Disable property to true if no results are found by a preceding task.