Script Map Replace Transformation
Data flow transformation performing find-and-replace transformation in specified input columns using dictionary object. Each key from the dictionary is searched in the input column and if found replaced with the related value.
The script has the following parameters:
- InputColumns - selects list of columns to be transformed.
- MapVariable - select variable containing mapping object. You can use the Dictionary Destination script to setup the object.
- CaseSensitive - indicates whether the search is case-sensitive.
Ready to give it a try?
COZYROC SSIS+ Components Suite is free for testing in your development environment.