Hi,
I am receiving special characters from source system, i have incorporated "Unicode" for all the varchar columns in the source stage and continued it till target. With this i am able to bring in the special characters. However my project has 200 jobs where this change needs to be implemented. Its a bit effort to assign the columns to unicode in all 200 jobs.
Is there a way where i can assign the Unicode extension to all varchar columns at project level ?
Thanks,
Naresh
Unicode Property at Project Level
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 425
- Joined: Sat Nov 19, 2005 9:26 am
- Location: New York City
- Contact:
I believe that the only option at that point -after importing the metadata to the DS jobs- is manually changing the property to Unicode or changing the type to NVarchar/NChar
Yo could try hacking a dsx export file and the reimport but that could become messy easily
Yo could try hacking a dsx export file and the reimport but that could become messy easily
Julio Rodriguez
ETL Developer by choice
"Sure we have lots of reasons for being rude - But no excuses
ETL Developer by choice
"Sure we have lots of reasons for being rude - But no excuses