Tuesday, September 27, 2005

SSIS Nugget: Get error descriptions *****

http://blogs.conchango.com/jamiethomson/archive/2005/08/08/1969.aspx

If you use an error output then you will find that you get given an error number and an error column (i.e. the column in which the error occurred) but you do not get an error description. Well not to worry because youo can get the error description using a script component.
Here I've built a data-flow that contains an error in the source data.

No comments: