SSIS : Creating an error output from a script component

I had to implement this today…

http://colinkirkby.blogspot.com/2007/01/ssis-creating-error-output-from-script.html

I have a script component in SSIS that could have exceptions that need to be handled gracefully, row-by-row, and logged as such. This blog post contained all I needed!

SSIS DataFlow Discoverer

I have a pretty large ETL project I’m working on. I was getting the generic (read unhelpful) error message when records were not writing to my target database. It told me that there was a constraint violation, and gave me a column number.

Mind you, this isn’t the number corresponding with the column in the database. Rather, it was a number corresponding to a derived column in the SSIS package. Ugh!!! How was I to know what column it was? Enter the SSIS DataFlow Discoverer.

I found this blog:

http://bennyaustin.wordpress.com/2011/02/04/ssis-name-of-errorcolumn/

Referencing this tool:

http://dfld.codeplex.com/

After running the tool on my DTSX file, I was able to use the column number in a query against the database the tool generated and, voila! It helped get to the column in question much more quickly than having to do it manually by process of elimination!

Enjoy!