Share via


Bulk Insert Task Editor (Connection Page)

Use the Connection page of the Bulk Insert Task Editor dialog box to specify the source and destination of the bulk insert operation and the format to use.

To learn about working with bulk inserts, see Bulk Insert Task and Format Files for Importing or Exporting Data.

Options

  • DestinationTable
    Type the name of the destination table or view or select a table or view in the list.
  • Format
    Select the source of the format for the bulk insert. This property has the options listed in the following table.

    Value Description

    Use File

    Select a file containing the format specification. Selecting this option displays the dynamic option, FormatFile.

    Specify

    Specify the format. Selecting this option displays the dynamic options, RowDelimiter and ColumnDelimiter.

  • Refresh Tables
    Refresh the list of tables and views.

Format Dynamic Options

Format = Use File

  • FormatFile
    Type the path of the format file or click the ellipsis button (…) to locate the format file.

Format = Specify

  • RowDelimiter
    Specify the row delimiter in the source file. The default value is {CR}{LF}.
  • ColumnDelimiter
    Specify the column delimiter in the source file. The default is Tab.

See Also

Reference

Bulk Insert Task Editor (General Page)
Bulk Insert Task Editor (Options Page)
Expressions Page

Other Resources

Integration Services Error and Message Reference
BULK INSERT (Transact-SQL)
Working with Format Files
Creating Package Control Flow

Help and Information

Getting SQL Server 2005 Assistance