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…

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.

Thanks for your response Todd.They are asking for best approaches documents to handle the errors in ssis. Thanks CMK..

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.

check http://plexussql.blogspot.com/2010/01/emailing-error-log-file-as-attachments.htmlSincerely SH -- MVP, MCITP 2008, MCTS 2008 & 2005 -- Please kindly mark the post(s) that answered your question and/or vote for the post(s).