Hi, I'll try to present detailed question here.I have created a new package ,I have a data flow task in the control flow .I then got oledb source component to the data flow pane.In the oledb source editor what is the use of error output option .What kind of errors can be expected with sources? like data integration is maintained at the database level itself.so what's the specific use of these. Regards Chaithanya M

Error Output Option helps to handle error handling . e.g. what you want to do incase of any error in source data --> ignore the failure, redirect the row, or fail the component same in case of truncation. What kind of errors can be expected with sources You may expect truncation error datatype mismatch kind of error from source data for more details see http://msdn.microsoft.com/en-us/library/ms186998.aspxCheers, Shailesh

Hi, Maybe you are deriving some value from multiple columns, and for any record Divided by Zero Error occure, So in those cases you might want to ignore or redirect. This feature is there but I never used this , Maybe somebody else have used this in better situation in real time. Want to know too! Thanks http://sqlage.blogspot.com/