SQL Server Performance

SSIS, Write all package errors to one flat file

Discussion in 'SQL Server 2005 Integration Services' started by Ismailc, Mar 26, 2009.

  1. Ismailc New Member

    Hi, I need help please.
    I have several tasks, with a lot of error checking with sending email on each task failure. This worked fine because i had a variable in row count & pass the entire row to a csv file. So i could see the entire record. But I had to many emails with different error csv files.
    I would like one error txt file for all the errors, so it appends the file with all the errors. but now i wont have control of the field error, but at least show the line no with it's value.
    Please Assist! Regards
  2. hendrik.sudianto New Member

    Hi,
    You can use SSIS logging. Add SSIS log provider for Text Files as provider type, and add event OnError in order to log error to the file.
  3. Ismailc New Member

    Thank You for the assist, tried but unsuccessful.
    I tried creating one csv file with columns based on expressions, add a derived column & add rows
    it works for one task but then on another task it overwrites the file, tried using raw file destination & append but that does not work.
    How do i in derived column, capture the record line in expression?
    Regards

Share This Page