Using Data Transformation Services, part 4: Using the DTS Designer Objects (continued-2) - Column Transformation Code: Step 3
(Page 9 of 10 )
In the finals step we shall capitalize all the characters in the 'City' field. This can be accomplished using the built-in transformation, Uppercase String mentioned in the list of transformations earlier. Highlighting Col004 (this will be mapped to Col003 of the destination), click on New and choose the Uppercase String from the Create New Transformation window. This takes you to the Transformation Options window where you choose the source column as Col004, the destination column as Col003 and then click the General tab and then click on Properties of the transformation. The following window appears as shown.
Click OK to all and close the screens to comeback to the Transform Data Task Properties window. You may want to test this transformation in this screen to see the View Data window as shown.
Finally we shall delete the PostalCode field by simply deleting this link. The final screen should appear as follows.
Next: Executing the Package >>
More MS SQL Server Articles
More By Jayaram Krishnaswamy
