DSXchange

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

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

Thank You !!