This table will have four columns with the columns headings: CustomerID,
CFname, CLname, and CRdate. This can be created by the statement shown in the
following screenshot, in SQL Server 2005.
??? ??? ??? ??? ???
Chapter 7
[ 125 ]
Create Table[dbo].[TestCustomer](
[CustomerID][int]Identity(1,1) not null,
[CFname][nchar](20)null,
[CLname][nchar](20)null,
[CRdate][smalldatetime]null,
Constraint[PK_TestCustomer]Primary Key Clustered
([CustomerID]ASC)) on [Primary]
1. Open the Query window in the Microsoft SQL Server Management Studio
and type in the above statement.
2. After verifying the SQL Syntax by clicking on the verify syntax symbol, click
on the Execute symbol (!).
3. Now go to the MyNorthwind database, in which this table is created. Make a
right click on the Tables node, and from the drop-down choose Refresh.
4. Expand the Tables node. Locate the table, TestCustomer. Make a right click
on the TestCustomer table and choose Open Table.
Data Transfer from a Text File using the Bulk Insert Task
[ 126 ]
This displays the TestCustomer table in the management studio as shown in the
following screenshot.
Step 3: Create a BI Project and Add a Bulk
Insert Task
1. Create a Business Intelligence project Ch7 and change the default name of the
package from Default.dtsx to BulkInsert.dtsx.
2. Drag and drop a Bulk Insert Task from the Control Flow items group, or by
double-clicking the Bulk Insert Task in the Toolbox when the Control Flow
page of the canvas is highlighted.
Pages:
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102