Hello All, Recently I've been involved in developing a SSIS Package where I'm decoding / making relevant comments on the error I'm getting while validating data. For this, decoding / commenting, I'm using script component where I've added an error output column of string format and in the script I'm assigning the relevant string. Now after finishing all the validation, I saw that there are 5 script component that I'm using for tracking the different erorrs. Now I'll work on removing all the 5 different script component and will try to use only one script component to report all the errors. As I'm currently working on it and don't know the solution, I want to ask you guys also to look into this scenario and suggest if you have already done something similar to this. Regards,

What you need is handling errors in SSIS , you can use this Link and next step will be to have a "Package Managment Framwork" see chapter 2 of this book "Link"Sincerely SH -- MCITP 2008, MCTS 2008 & 2005 -- Please kindly mark the post(s) that answered your question and/or vote for the post(s).

What you need is handling errors in SSIS , you can use this Link and next step will be to have a "Package Managment Framwork" see chapter 2 of this book "Link"Sincerely SH -- MCITP 2008, MCTS 2008 & 2005 -- Please kindly mark the post(s) that answered your question and/or vote for the post(s).