Data Driven Query Task Properties (Options Tab)

DTS Designer

DTS Designer Help

Data Driven Query Task Properties (Options Tab)

Use this tab to send rows to an exception file, determine the format of that file, and set the error count at which package execution should cease. The exception files are stored on a local or mapped drive.

Options
Exception file area

Name

Specify the path and name of the file where exception records will be written. If the file does not exist at package run time, the file will be created. The file does not have a default extension assigned to it.

Click the browse (...) button to search the local computer or mapped drives for an existing exception file. If an existing exception file is used, the status and error information for the package will be appended.

File type area

7.0 format

Select to save the exception file in 7.0 format. This format is useful if an exception file parser was written for Microsoft® SQL Server™ version 7.0 exception files, as exception files using this backward-compatible format can still be used in the parser.

Error text

Specify that any errors encountered during the task execution be recorded. Selecting this option records information such as the Data Transformation Services (DTS) package name, execution start and completion time, and other data in the exception log.

Source error rows

Specify that a separate exception file be created to contain all the rows from the source data that did not get written to the binding table. Formatting of the file is done according to the File format properties specified. The file name will be the same as the name specified in the Name field with the extension .Source appended to the name, and the file will be located in the same directory as the exception file.

Dest error rows

Create a separate exception file to record error information on rows that fail when attempting to write to the destination. The file name will be the same as the name specified in the Name field with the extension .Dest appended to the name, and the file will be located in the same directory as the exception file.

File format area

Row delimiter

Select the delimiter used to separate rows of data in the exception file. A carriage return/line feed {CR}{LF} is used by default.

Column delimiter

Select the delimiter used to separate the columns of data in the exception file. A vertical bar is used by default.

Text qualifier

Specify which character marks are to be used in the delimited data file to qualify text. Choose from: Double Quote {"}; Single Quote {'}; and <none>. You also can type in a character to use as the text qualifier.

Data movement area

Max error count

Set a limit on the number of errors allowed before processing is terminated for the task. When the Max error count value is exceeded, task execution is terminated. The default is zero, which means that the task will terminate upon the first error.

Fetch buffer size

Set the number of rows of data being fetched at the source during data movement. Generally, you should not need to adjust this value unless it is necessary to optimize the characteristics of the data provider.

First row

Specify the first row of data to be moved. This is useful if the first row consists of column headings, or, if the first part of a data source has been copied, you can set this value to the row number where processing stopped in an earlier data pump operation.

Last row

Specify the last row of data to move.

See Also

Tasks That Transform Data

Data Driven Query Task