Retrieving Error Message From Trigger During Data Load

• craig.donoghue 48563

  Mr or Mrs. 500

  Points: 524

  More actions

  January 13, 2015 at 3:39 pm

  #313631

  Hi All,

  I have a dataflow task that is loading data from a flatfile (csv) into a SQL database. I have redirected any errors to a flatfile, but what I need to do is return the error message that is generated within the table trigger to the output file.

  Is this possible? I've noticed that when errors are set to fail component the error message shows in the Progress tab, but not when set to redirect rows.

  Thanks in advance,

  Craig