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.
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.