It has four options that can be seen by clicking on the drop-down.
12. Use the default, Existing File. Click on the Browse??¦ button, which opens a
Select File dialog. Locate the file created earlier in the C:\ drive, SsisBulk.
txt and click on the Open button in that dialog.
13. Click on the OK button in the File Connection Manager Editor that shows
up again.
This will add the file information to the Bulk Insert Task Editor window, as
shown in the following screenshot.
Chapter 7
[ 131 ]
14. Click on the list item Options.
This opens the following window where there are several options you can
choose as shown. Here, only the FirstRow will be changed from 1 to 2. This is
because insertion into table begins from the second row in the text file, as the
first row contains column headers.
15. Click on the OK button on the Bulk Insert Task Editor's window.
This completes the configuration of the Bulk Insert Task. In this exercise, the
Expressions branch is not configured because the focus is on a simple Bulk Insert
Task configuration.
Step 5: Build and Execute the Package
1. Build the project and execute the package.
The Bulk Insert Task object first turns yellow and then to green, indicating
that the task has successfully executed.
2. From the Debug menu item, choose Stop Debugging.
Data Transfer from a Text File using the Bulk Insert Task
[ 132 ]
3. In the SQL Server Management Studio, review the table dbo.TestCustomer.
You will see the contents of the table as shown in the following screenshot.
Pages:
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105