Post reply

Need help with error handling in SSIS

  • October 6, 2009 at 1:01 am

    #136326

    Hi

    I think there have been related posts in this matter but I wish to know more about error handling in SSIS (step-by-step). I tried configuring the "Logging" option under SSIS where provider type I've specified is "SSIS log provider for Windows Event Log". But this doesnt seem to work for me. I'm not sure where the error's getting logged??

    Please let me know how to go about this step-by-step

    Thanks

  • October 6, 2009 at 1:16 am

    #1062110

    I got this to work somewhat..

    All this while I was executing a single task but I debugged my package now and it started logging into the text file and so on (whichever option is selected in provider type)

    Anyway any more info on error handling is welcome.

  • October 7, 2009 at 4:11 am

    #1062663

    You might would want to use some tools like SSIS Log Analyzer.

    Regards,

    Siddharth Mehta

  • October 7, 2009 at 6:47 am

    #1062734

    In my experience with DW, there are 2 kinds of errors:

    1. SSIS fails

    2. bad data

    for #1 of course I use the built in logging to a SQL table (just

    my preference). and i use the error event handler to update

    my audit table that tells me my package failed etc...

    for #2 I actually have an Errors table in my Audit database,

    I write out all the bad data records with user-friendly descriptions

    so I can send to users to fix.

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

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