Post reply

Continue processing after logging errror in Data Flow Task

  • July 29, 2008 at 5:44 am

    #130190

    I am reading in a text file into a SQL table, and if the data in a row in the file is invalid, I want to write it to an error log text file, but I want to continue processing the file. I have the "On Failure" task writing to the error log file, but how can I get it to continue processing the file?

    Thanks!

    Michael

  • July 30, 2008 at 12:38 pm

    #850781

    In the On Error processing, under Error, do you have the Redirect Row option selected or Fail Component? If you select Redirect Row, the error should be written to the error log and the package should continue processing.

  • July 31, 2008 at 9:07 am

    #851328

    Worked! Thanks!!!!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply