Stop SSIS job if row count = 0

• artoo

  SSC-Addicted

  Points: 445

  More actions

  June 10, 2008 at 8:00 am

  #192183

  I have an SSIS job that queries a table in my database and outputs the results to an Excel file. If the query returns no rows I don't want the job to create the Excel file. How do I go about this? I'm new to SSIS so idiot proof instructions would be gratefully appreciated.

• Ken Simmons

  SSCertifiable

  Points: 7822

  More actions

  June 10, 2008 at 8:09 am

  #826669

  Here is a cool article about dynamic workflow.

  http://www.mssqltips.com/tip.asp?tip=1487