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
Connection
Select an OLE DB connection manager in the list, or click <New connection...> to create a new connection.Related Topics:OLE DB Connection Manager, Configure OLE DB Connection Manager
- 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.
File
Select a File or Flat File connection manager in the list, or click <New connection...> to create a new connection.If you access the source file by using a Flat File connection manager, the Bulk Insert task does not use the format specified in the Flat File connection manager. Instead, the Bulk Insert task uses either the format specified in a format file or the values of the RowDelimiter and ColumnDelimiter properties of the task.
Related Topics:File Connection Manager, File Connection Manager Editor, Flat File Connection Manager, Flat File Connection Manager Editor (General Page), Flat File Connection Manager Editor (Columns Page), Flat File Connection Manager Editor (Advanced Page)
- 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