Hi,

I have a DTS Package that executes a simple stored
procedure and exports the results into a text file. The
problem I have is with some of the German databases. When
I execute the procedures manually the data in the table
looks correct, however when this procedure is executed via
the DTS package some of the German characters are
incorrect.

For Example.

Should be - amü-Umzüge;Müller GmbH
Appears as - am�-Umz�ge;M�ller GmbH

Does anyone know why this happens and how to fix it.

Thanks for your help.

I believe that I have found the solution to this problem.

The databases involved have OEM codepages and I have found
that by declaring the column in the table that is sent to
the text file as a unicode datatype (nchar, nvarchar,
ntext) then the charcters are transfered successfully.

For a database on an ANSI codepage no change was necessary.