How to handle errors in ssis ..? could you tell me the process.

Just search for "error handling in ssis" and you will get a lot of links. Few are: http://technet.microsoft.com/en-us/library/cc304419.aspx http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/62662/ http://agilebi.com/jwelch/2007/05/05/handling-multiple-errors-in-ssis/ Look for precedence constraints and event handlers in SSIS to get more ways to handle errorsNitesh Rai- Please mark the post as answered if it answers your question