Using Data Transformation Services, part 3: Using the DTS Designer Objects (continued) - Create a Transform Data Task

(Page 7 of 9 )

We will use the Data Transformation task to modify the mapping from FirstCopy to SecondCopy. Place the cursor on the connecting link from FirstCopy to SecondCopy, and when it changes to an East-West pointing cursor, right click to look at the properties of the Data Transformation task as shown below. The Data Transformation Properties window opens with the default Source tab as shown. This is the FirstCopy text file.

Clicking on the Destination brings the following into view. This is the SecondCopy corresponding to Destin2.txt.

The next tab is the Transformations tab. Clicking this tab reveals the following, where we have deleted one of the columns from being mapped. The PostalCode has been dropped.

When we click OK to this, the SecondCopy will be created with the PostalCode field removed. It is possible to test the Task, edit and delete the task in this window. We assume that dropping a column is all that is required, and therefore click OK.

Next: Verify the results of transformation >>
 

More MS SQL Server Articles
More By Jayaram Krishnaswamy

Comments On: Using Data Transformation Services, part 3: Using the DTS Designer Objects (continued)

>>> Be the FIRST to comment on this article!