Hi,
I have a dts package that works correctly apart from one issue. I
have a number of items to import that have fench names. The special
characters in the names get translated into something different. I set
the autotranslate option to false on the connection objects but this
didn't help. I also changed the column type to nvarchar but again this
didn't solve the issue. Any ideas would be very welcome.

regards
Ciaran

It will not work to specify nvarchar when the source file is not Unicode. The
source file should be saved as a Unicode file in the first place.

Charles Kangai, MCT, MCDBA
Author of Learning Tree's 4-day course: "SQL Server 2005 Integration
Services" http://www.learningtree.com/courses/134.htm
Author of Learning Tree's 4-day course: "SQL Server Reporting Services"
http://www.learningtree.com/courses/523.htm
email alias: charles
email domain: kangai.demon.co.uk





"hursting" wrote: