This brings in the Bulk Insert Task into the canvas. This icon is displayed with a
white cross in a red circle indicating that its configuration is not complete.
Step 4: Configure the Bulk Insert Task
1. Right click the Bulk Insert Task and from the drop-down choose Edit??¦.
This brings up the Bulk Insert Task editor as shown in the following
screenshot.
Chapter 7
[ 127 ]
2. Provide a meaningful Name and Description by changing the default text
values shown in the previous screenshot.
For the Name field, "Bulk Insert TestCustomer Task" is chosen. For the
Description field, "Insert Customer Info from a text file" is chosen for
this exercise.
3. Click on the Connection list item in the left-hand-side.
This opens the Connection page as shown in the following screenshot. This
has three major nodes: Destination Connection, Format, and Source
Connection. The destination is the SQL Server. Here, you should specify
the table created earlier. The Format node has three items: Format,
RowDelimiter, and ColumnDelimiter. Format has two options, Specify
and Use File. The Specify option will be used. The RowDelimiter and
ColumnDelimiter specify how the rows and columns are delimited in
the source text file. For this example, only the ColumnDelimiter was
changed from tab (default) to Comma{,} to match the text file. In the
Source Connection node, you will be required to locate the text file you
created earlier.
Data Transfer from a Text File using the Bulk Insert Task
[ 128 ]
4.
Pages:
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103