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.