if any one asks me in interview,how do you handle errors in ssis? what should i say if they asked me like this ... please give reply for this...

there are two types of errors in SSIS: 1- Control Flow Errors which you can handle them with Event handlers , use appropriate event handler like OnError to handle these types of errors. also you can use Failure Precedence constraint to redirect control flow when task failed. this is more information about SSIS event handler: http://msdn.microsoft.com/en-us/library/ms140223.aspx 2- Data Flow Errors which you can handle them with CONFIGURE ERROR OUTPUT in some or sources / transformations / destination . you can fetch BAD data rows with configuring error output into another destination or ignore them. this is a sample of configure error output : http://www.rad.pasfu.com/index.php?/archives/23-How-to-handle-Failed-Rows-in-a-Data-Flow.html http://www.rad.pasfu.com

You would handle them based on your experience with SSIS. How have you handled errors in the past? Start there. If you don't have experience with handling errors in SSIS, I, as an interviewer, would be more impressed with an interviewee who is man enough to admit that fact. If your successful interview is based on that question, your potential new boss is going to be pissed if they find out you bluffed the answer.Todd C - MSCTS SQL Server 2005 - Please mark posts as answered where appropriate.