SSIS Toolbox: Character Map
The Character Map transform makes changes to string functions. For instance, it can upper case a string (exactly like the UPPER function or it can do a couple of other things that most of us will probably never use. As such, this will be a quick one.
Step 1: Create a OLE DB source
- Click on the Data Flow tab, hit the link and create a data flow.
- Drag a OLE DB source to the desktop.
- Configure it as follows:
- OLE DB connection manager: Adventureworks 2012. Click new and create if necessary.
- Data access mode: SQL command.
- SQL command text: “SELECT name FROM production.location”.
- Click the columns tab..
- Click OK to close.
Step 2: Multicast the results
Drag a Multicast transform to the Data Flow and connect the OLE DB source to it. You don’t need to configure anything else.
- Drag two Character Map transforms to the Data Flow.
- Connect both Character Map transforms to the Multicast transform.
- Configure the first transform.
- Name it Uppercase (F2 on the transform or click on the name).
- Double-click the transform to open it.
- Check the name box (it will be the only one).
- Set the Operation field to Uppercase.
- Click OK to close it.
- Configure the second transform exactly the same except for the following.Configure the first transform.
- Name it Chinese.
- Set the Operation field to “Simplified Chinese” and “Byte Reversal”.
Step 4: Create two UNION ALL and configure them both to use the data viewer.
- Drag two UNION ALL transforms to the Data Flow.
- Connect them to the two Character Map transforms.
- On the paths from the Character Map transforms to the UNION ALL transforms, double-click, click the “Data Viewer Tab” and check the “Enable data viewer” box.
- Click OK to close them.
Run the package. If you don’t get anything in Chinese, I would say don’t worry about it, and move on, I did.