locked
How To Handle Errors In SSIS? RRS feed

  • Question

  • Hi All,

    Still my work is in Analysis. I want prepare the documents to handling errors, logging, email notification. Please help me  how to prepare the technical document. Source is SQLSERVER tables.

     

    Thanks

     

    CMK…

     

    Wednesday, October 20, 2010 5:20 PM

Answers

  • Well, what I do is add an Event Handler to the root package node, connected to the On Task Failed event. In that is a single Send Mail task with many of its properties set via Expressions and Configurations (To, Subject, and Message for starters).

    Actually, a best practice would be to get together a robust Template package with all the Configurations, global Variables, logging, all that ancillary stuff, then COPY it every time you need to create a new package. That way, you don't have to recreate stuff.


    Todd C - MSCTS SQL Server 2005 - Please mark posts as answered where appropriate.
    • Marked as answer by cmk1 Wednesday, October 20, 2010 7:33 PM
    Wednesday, October 20, 2010 7:02 PM

All replies

  • You are going to have to be more specific about what you want. SSIS has stock tasks for email, and good functionality for logging.

    "prepare the technical document" What does that mean?


    Todd C - MSCTS SQL Server 2005 - Please mark posts as answered where appropriate.
    Wednesday, October 20, 2010 6:41 PM
  • Thanks for your response Todd.They are asking for best approaches documents to handle the errors in ssis.

    Thanks

    CMK..

     

    Wednesday, October 20, 2010 6:54 PM
  • Well, what I do is add an Event Handler to the root package node, connected to the On Task Failed event. In that is a single Send Mail task with many of its properties set via Expressions and Configurations (To, Subject, and Message for starters).

    Actually, a best practice would be to get together a robust Template package with all the Configurations, global Variables, logging, all that ancillary stuff, then COPY it every time you need to create a new package. That way, you don't have to recreate stuff.


    Todd C - MSCTS SQL Server 2005 - Please mark posts as answered where appropriate.
    • Marked as answer by cmk1 Wednesday, October 20, 2010 7:33 PM
    Wednesday, October 20, 2010 7:02 PM
  • check http://plexussql.blogspot.com/2010/01/emailing-error-log-file-as-attachments.html
    Sincerely SH -- MVP, MCITP 2008, MCTS 2008 & 2005 -- Please kindly mark the post(s) that answered your question and/or vote for the post(s).
    Wednesday, October 20, 2010 7:21 PM