Scenario:
Let’s say we are extracting data from a source and we have to
write to flat file or excel but before we write data we want to format one
column to lower case and other column to upper case.
Solution:
SSIS provided us a transformation called “Character Map”
that can perform different operations on string type columns. We can either add
a new column or we can do In-place change for that column. We used Uppercase
and lowercase operations on CountryName and SalePersonName respectively. The same
operations can be done by using Derived column transformation.
As shown below, We added a new column CountryName_Upper and used Uppercase as operation on CountryName column. For SalePersonName we did In-place change and changed to lowercase.
 |
| How to use Character Map Transformation in SSIS Package to convert string values to Lowercase or UpperCase |
Output snapshot
 |
| What is Character Map Transformation and How to use in SSIS Package |
Video Demo : How to use Character Map Transformation in SSIS Package
To learn more about different operations available in Character Map transformation, Please visit
Mua vé tại Aivivu, tham khảo
ReplyDeletemua ve may bay di my
khi nào có chuyến bay từ mỹ về việt nam
các chuyến bay từ nhật bản về hà nội hôm nay
chuyến bay từ đức về hà nội hôm nay
giá vé máy bay từ Vancouver về việt nam
Các chuyến bay từ Incheon về Hà Nội hôm nay
khách sạn cách ly ở nha trang
ve may bay chuyen gia nuoc ngoai
Among the trendy superhero wear gaining fame fast is the Black Panther costume. This makes it the best outfit for cosplay and Halloween or any other dress up event. It has all the usual superhero and superheroine flare and it has some slight improvement from the usual attires donned by other screen heroes. hire Black Panther
ReplyDelete