Using Data Transformation Services, part 4: Using the DTS Designer Objects (continued-2) - The Transform Data Task
(Page 5 of 10 )
From the Task Collection click on the Data Transform Task and place it on the Text file first and then place it on the MS Access icon next. A connecting link will be developed. The second tutorial illustrates this. The design pane now has the source and the destination with the connecting, data transform task as shown in this picture.
Place the cursor on the vertical connecting line and the cursor changes to a double headed East<->West cursor type. Now right click this Data Transform task to reveal its properties window as shown in this picture.
The window opens with the default tab, Source, namely, the text file in this case.
A meaningful description may be typed in. In this tutorial the default is accepted. The Table/View is the only option for this connection. It is possible to have a preview of this source by clicking the Preview... button. If you click OK to this you will be faced with a Package error since all information for the transform has not been specified at this point.
Click on the next tab, Destination. This brings up this next, Create Table window. It already has the name of the text file name as default table name. Although changes can be made to the table properties, defaults are accepted by clicking OK since our focus is on transformation of columns. The destination information now appears as shown in this picture.
Now we come to the next tab, the Transformations tab. Click on the Transformations tab, and this brings up this screen. This is where transformations are to be defined. When it pops up for the first time, column to column mapping lines are in place although no transformation in particular is selected as shown in this picture. For five columns five transformations are in place.
Next: Using the Transform Task >>
More MS SQL Server Articles
More By Jayaram Krishnaswamy
