Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  DTS global variable data types driving me nuts

Author  Topic  kapsolas Starting Member 1 Post Posted - 2006-01-24 : 10:12:30 I have a table which has a column of type nvarchar, thus I can store unicode characters with in it. When I set up my execute sql task in sql and assigned the select column from table result set to be a global variable, it does not retain the unicode characters. specifically I am trying to consume the resultset in an activex file. i tried the other and string types in the global variable types with no luck. any ideas?