The Basic Map component allows you to easily transform column data in a data-flow by correlating input values to outputs and specifying the behavior when an unmapped value is encountered.
The configuration interface lets you easily select the columns that you want to transform, and creates a page for each.
For each column that you want to map, you can then add a series of mapping entries. String, GUID and number mappings are all supported. You can also specify an alternative output column (creating one if required - the default is to write the transformed value back to the same column), and the behaviour when no match entry is found. In this case you can configure the component to ignore unmatched values, to fail, to set the output to NULL or a specified value, or to route the row to the error output.
All BlueSSIS data-flow components support properties 'Fail on truncation' and 'Unicode mode', allowing you to define applicable truncation and Unicode settings. These properties can be found in the Visual Studio/BIDS Properties window as shown below :
