October 20, 2005 at 8:27 pm
Hi guys,
I was wondering whether there is a way of storing the errors encountered in a Copy Column type of transformation onto a table. Currently i use the Exception file and that isnt really what we need. We would like to be able to store the record number that caused the problem, and the error description seperately so they are easily accessible.
Any ideas?
Thanks
October 21, 2005 at 5:52 am
You are not going to get dts to do this easily as there is no built in functionailty in dts.
The way I approached this in the past is to perform 2 imports. The first imports all the records into a table where everything is set to varchar, hence there should be no failures. The second import uses this table as a source and imports into the live table.
To find the failing rows, you can write a query to see which records are in the temp table, but not in live.
Very crude, but it does work, unless the record is so corrupt it does not make it into the temp table.
If you want something more dynamic, dts is the wrong tool. Informatica is one tool that generates an exception report for you.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply