August 25, 2014 at 10:21 pm
I am writing a package in 2008R2 and I simply want to log any error or truncations from my data flow into a table in sqlserver. I am pulling from Oracle 10g with and OLEDB connection dropping the data into an OLEDB connection going to a Sql Server 2008R2 table. When I have truncated values or errors, I want to log the error column, error code or description, task name and one field that concatenates all the data in that row. What is the best approach for this?
Thank you,
August 26, 2014 at 12:56 am
rusty-757418 (8/25/2014)
I am writing a package in 2008R2 and I simply want to log any error or truncations from my data flow into a table in sqlserver. I am pulling from Oracle 10g with and OLEDB connection dropping the data into an OLEDB connection going to a Sql Server 2008R2 table. When I have truncated values or errors, I want to log the error column, error code or description, task name and one field that concatenates all the data in that row. What is the best approach for this?Thank you,
Each component in the data flow has an error path (the red arrow). You can link these to a seperate OLE DB destination and write immediately all the error rows to that destination.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply