December 5, 2005 at 4:09 am
Hi,
I have enabled the source and destination exception error files. However, when the database returns an error, for example, due to the NULL constraint, Primary Key, Foreign Key violation, the source and /or destination data is not logged. the exception file only states the nature of error.
The record number (for example, the 167th record in an input file of 2 million records) is not captured. All I get is the total number of records in the source file.
How do I get the number of record (in source) that caused the error? and how do I get the source and / or destination data?
Thanks!
December 8, 2005 at 8:00 am
This was removed by the editor as SPAM
December 8, 2005 at 9:34 am
When I need this information I am able to get it from the exception file. I use 7.0 format and it contains the number of failed rows and the row that failed. If you add some parseing of this file as final task (ActiveX) you should be able to get a pretty good table of errors.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply