I am in a bit of a dilemma. I have a DTS package set up to query a table
some some string concatenation and eventually spit out the results to a text
file.

When running the T-SQL code from query analyzer, my results look perfect as
they should, the correct encoding is retained and all, ex António José.

However when same code is executed through the DTS package (Transform data
task) what I get in the exported file is Ant¢nio Jos[box].

I have been playing with this for a day about and can't seems to track down
what the issue might be.

I have tried Unicode, OEM, and ANSI with no good results. Other packages
which are sent to ANSI work just fine.

Any ideas would be helpful.

thanks.

doh! was my table declaration. I had my fields declared as varchar which
internally automatically converts the text to ASCII, converted the table to a
nvarchar and everything works fine..

Hope someone else digging through the newsgroups some day finds this helpful.

"kapsolas" wrote: