title: Conditional statement in SSIS
body: <p>Is it possible to have a conditional statement in the flat file destination activity?</p>
  
  <p>The condition is that when the SQL Query generates rows (or when the number of rows is greater than 0), then it will export the results to a txt file.</p>
  
  <p>I tried using RowCount and Conditional Split activities after the ADO source activity but it still generates the reports even if there are no rows retrieved.</p>
  
  <p>Below is the screenshot of the data flow activity:</p>
  
  <p><img src="https://i.stack.imgur.com/ObcUi.jpg" alt="enter image description here"></p>