ETL and Data Integration tools - Modern ETL software for everyone

I have a text file that has a number of names of people that have german characters. An example of one of these names is Jürisch, Sven. After I use transformation services to import it into MSSQL table, the name is changed to Jürisch, Sven.

How can I keep the integrity of the characters during the transformation process?

We know that MSSQL will accept the text field without using ELT Pro, so we are fairly confident that the problem is occuring during the transfomation, import process.

I am using ELT Processor Pro

Can you email us the following please
source file
table creation script
transformation script
and we will check it for you

Mike