Limit the error rows redirected in a dataflow

• venus.pvr

  SSCarpal Tunnel

  Points: 4813

  More actions

  January 3, 2012 at 2:04 pm

  #265717

  Hi,

  While loading data from a file, I am redirecting the error rows in the data flow to a log file. I need to make sure that if the error rows are greater than 10,000, the package fails. Please advise if I can accomplish this in SSIS 2008.

  Thanks and Regards,

  Praveena

• Elliott Whitlow

  SSC Guru

  Points: 102402

  More actions

  January 3, 2012 at 6:30 pm

  #1428056

  I'd probably put a Row Count component in the flow and then use the value as part of the contraints to fail the package.

  CEWII