Bulk Insert Task Properties (General Tab)

DTS Designer

DTS Designer Help

Bulk Insert Task Properties (General Tab)

Use this tab to specify the properties that will direct the Bulk Insert task to import data from a data file and copy it to the specified Microsoft® SQL Server™ table or view.

The parameters in the Bulk Insert properties map to most of the parameters in the Bulk Insert command. For more information about any of the options in the user interface, see BULK INSERT.

Options

Description

Describe the Bulk Insert task. This description becomes the label for the task placed on the Data Transformation Services (DTS) Designer design sheet.

Existing connection

Choose the SQL Server connection that specifies the appropriate destination database for the data.

Destination table

Specify the SQL Server table or view in the database to which the data is to be copied.

Refresh

Populate the database list on Microsoft Windows® 98 computers.

Source data file

Specify the name of the file containing the data to be copied. Click the browse (...) button to search for the source data file.

Use format file

Specify the full path and name of the format file. The format file describes the contents of the data file, which has been created using the bcp utility. Click the browse (...) button to search for the source data file.

Specify format

Specify the row and column delimiters in the source data file to ensure that the file will be parsed correctly when it is read.

Row delimiter
Specify the delimiter used to denote the end of a row for each line of data in the source file. A newline delimiter {LF} is used by default.
Column delimiter
Specify the delimiter used to denote the end of a column for each row in the source file. A tab is used by default.

Generate

Display the Select a data file and a format file dialog box, where you search for the source data file and its associated format file on the local computer, as well as on all mapped network drivers. Displays a preview of the data before the Bulk Insert task is saved or executed.

See Also

Bulk Insert Task

BulkInsertTask Object