From the course: SQL Server Integration Services
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Character Map row transformation - SQL Server Tutorial
From the course: SQL Server Integration Services
Character Map row transformation
- [Instructor] To start transforming the people data I'm going to apply a row transformation called Character Map. This transformation uses transact SQL string functions to modify the input data. With it, you could do things like converting or convert the text case to uppercase or lowercase. I'm going to add a Character Map transformation to the data flow. You can find it underneath the Other Transformation section here, and I'll click and drag one into my data flow. We're going to use this to convert the full name column from the original data set into all uppercase characters. The first thing we need to do is pass the input data into the transform. To do that, click the data source component and then click and drag the blue arrow and drop it onto Character Map. The blue arrow represents the data that was successfully retrieved by the data source connection. The red arrow represents the data that comes out of the error state if you configured that in the data source properties. Once…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
-
(Locked)
Data flow components1m 49s
-
(Locked)
Extracting data from a source5m 43s
-
(Locked)
Understand transformations1m 15s
-
(Locked)
Character Map row transformation3m 50s
-
(Locked)
Conditional Split transformation5m 3s
-
(Locked)
Rowset transformations2m 25s
-
(Locked)
Loading data to a destination5m 37s
-
(Locked)
Prevent duplicate records2m 52s
-
(Locked)
-
-
-