Hi, Can any1 tell me how i can get the name of an error column and the description of the error and then save it in a table in the database. I dont want to use a script component. Thanks

See this component: http://eod.codeplex.com/ Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com

you can get Error Code and Description with CONFIGURE ERROR OUTPUT, also you can catch bad data row which caused error. on source/transformation/destination which you want to catch error , just CONFIGURE ERROR OUTPUT. if this doesn't make sense for you tell us more about what you trying to do and we could help better thenhttp://www.rad.pasfu.com

You can use "Enhanced Error Component" (Third party transformation) Let us TRY this | Mail me My Blog :: http://quest4gen.blogspot.com/

Thank You For the Help!!!

I dont want to use a script component. Why not? Its the best way that I can think of. I was wrong, sorry. See below. http://sqlblog.com/blogs/jamie_thomson/ | @jamiet | About me

I dont want to use a script component. Why not? Its the best way that I can think of. http://sqlblog.com/blogs/jamie_thomson/ | @jamiet | About me Error description is easy, but get you get the error column name with a Script Component?Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com

Error description is easy, but get you get the error column name with a Script Component? Ah good point. I've just been looking at this and have reminded myself why its (usually) impossible to get it. The ID in the ErrorCode column refers to a column that will probably not be in the input. Because of this any third party components (e.g. http://sqlblogcasts.com/files/3/transforms/entry2.aspx) have a slightly hacky way around this that (I believe) involve you feeding the original output back into the third party component. I don't see why it wouldn't work - but it doesn't feel like the right way of doing it. This is rather big limitation of SSIS. I can't remember if its been fixed in later versions or not.http://sqlblog.com/blogs/jamie_thomson/ | @jamiet | About me

SQL 2011 or Denali has the error column detection or rather an error column directly available on error redirect of data flow task. Good news for all of us :-)Happy to help! Thanks. Regards and good Wishes, Deepak.

SQL 2011 or Denali has the error column detection or rather an error column directly available on error redirect of data flow task. Good news for all of us :-) Happy to help! Thanks. Regards and good Wishes, Deepak. Good stuff!! :) http://sqlblog.com/blogs/jamie_thomson/ | @jamiet | About me