December 4, 2015 at 3:25 pm
Hello,
I am a rookie when it comes to Script Task logging in SSIS.
I have a very simple SSIS ETL package that moves data from one table to another table. I am adding logging, but I am only able to log metadata (very cryptic: HRESULT 0xc020801c) . I am able to produce this error when I change the column name in the destination table, creating a mismatch. I would like to log the SQL error that would blatantly state the nature of the error as a column mismatch.
How can I log the SQL Error message that would report this error with the column name, etc.?
Thank you so very much for your time and experience.
Sincerely,
Matt
December 8, 2015 at 9:58 am
Hello,
Ok, I resolved it.
I found lines in the Script Task C# script that held the table name and row name for each individually processed column.
I stored these as they were parsed and in my exception, I inserted the table and row name.
Works great!
Thank you anyway!
Matt
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply