1. Open up your DTS file and select your source and target fields and click Datalink
2. Now, Right click on the target field and Edit Data Formula.. Click on calculated variable and put the source field like S1 and point the dropdown to String
3 Next, insert this calculated variable in the formula and voila!
4. This maps your source picklist field with text values to the target picklist fields
No comments:
Post a Comment