Post reply

Capture Success and Failure and Continue Execution of Package

  • May 4, 2012 at 7:03 am

    #255275

    Hi,

    I am very new to SSIS and am looking for some valuable input. I need to transfer csv files into a sql server db table. In the process, I need to generate the file which will tell me number of rows processed, number of rows that had errors and number of rows successfully inserted.

    Another thing is I need to continue with package execution even if there is an error.

    Here is what I have done so far.

    Created a Data Flow Task that has flat file source and destination OLE DB. I created logging using SSIS logging that creates a log file everytime the package is executed.

    The log file tells me how many rows are processed but does not tell me how many are inserted or failed.

    Also how can I continue to execute the package even when error occurs? I have looked into error handling events but haven't found any solution. I am looking for something simple and easy to follow .

    Thanks,

    DLR

  • May 4, 2012 at 7:06 am

    #1483527

    Most transforms have a setting on how to handle an error, set it to ignore. I would use package variables and a count transform to get your row counts.

  • May 4, 2012 at 10:53 am

    #1483697

    I tried to use the error output to redirect the error to a different table or even a flat file. In that case none of the rows are getting inserted in the sql server table.

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

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