Good afternoon,

I have a DTS script that creates an ASCII flat file. Our client now wants
to take the data in the AL32UTF8 character set, as they load it into Oracle.

Is there a function I can call within DTS to do the conversion as the file's
written, or do I have to convert the file afterwards?

Are there any recommended conversion tools or code samples?

As far as I can see, MultiByteToWideChar api call will only convert to
standard UTF8. Is that correct?

I'm using SQL Server 2000, SP3, on Windows 2000.

Many thanks,

Ben.