How to configure the data pump exception files (Enterprise Manager)

To configure the data pump exception files

1. On the Data Transformation Services (DTS) design sheet, double-click a Transform Data task or Data Driven Query task.

   You must have your source and destination connections defined before configuring a Transform Data task.

2. Click the Options tab.
   
   
3. Under Exception file, in the Name box, type a file path for the text file you want to use as an exception file, or click the browse (...) button to locate the file.

   If you enter a file that does not exist, the file will be created when the step associated with this transformation task is run.

4. Optionally, if you want to use the Microsoft® SQL Server™ 2000 data pump exception file options, then under File type, clear the 7.0 format check box and select the exception files you want to generate.
   
   
5. Under File format, select any additional options for the exception file.

See Also

DTS Connections

Tasks That Transform Data

Transform Data Task