El barto (3/26/2008)
Hi,One additional question... Is there a way when importing records using DTS to capture the line that the process fails on?.
If you're using a Transform Data task to import the data, you can designate exception files to capture source error rows.
Open the properties of the Transform Data task and go to the "Options" tab. Enter a name for the exception files and, in the "File type" section, uncheck "7.0 format" and check "Error text" and "Source error rows".
Execute the task and open the exception files when the task fails.
Greg