I am trying to write the contents of a nvarchar datatype field to a text file.

I have set it up as a dts package where I first populate my global variable
result set and then I access it from the activex script where i perform some
processing and write the results to a text file.

however the when writing the results I am missing all the international
characters. what global variable datatype will retain the unicode. When i try
to use some types other than string I get an error about not being able to
convert from BSTR to type <type selected>

Thanks,

Anyone have any feedback or ideas on this?
I am thinking now it might not be the global variable but maybe the way that
activex script is pulling the information from the result set. Is there an
certain way to handle unicode characters in the activex scripts?

Thanks,


"kapsolas" wrote: