Hallo all,
we have some dts packages on a production sql server, used for to import
text data. My country is Greece so a lot of greek characters are included in
the txt sources.
The organization providing the txts to our application, used to have them in
unicode format (2 bytes per character) and everything was ok.
As it seems so far they sudenly changed to utf 8 or to ansi (1 byte per
character - half size to the file) and now the import process returns error
messages (something like "row delimeter cannot be found")
In the dts designer, i tried to change the expected file format of the input
txt source file, however, i cannot find a "utf-8" option in the txt source
component at the dts designer.
The only options available are "unicode", "ansi" and "oem". None of all
these works, the unicode option doesn't work at all, the other two doesnt
display or interpret greek corectly.
Anyone else faced same issues?
im Looking forward to hearing any sugesstions or any ideas from you on how i
can overcome this issue. Its a production project. i didnt find anything
special on the internet.

Thank you very much,
Fotis Mylonas

Try opening the file in Notepad. Do a File | Save As. In the Encoding
drop-down, choose Unicode. Save to a new file name. Now try importing the
new file.

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




"Fotis Mylonas" wrote:

Thank you very much Charles, but i needed something more automated than
this.
its ok by now, i had to write some manual code to first convert the file
from utf-8 to ansi and then feed it to the dts package. i really think this
should have been an option in the drop down menu of the dts component and
not force me to write a separate application for to do the convertion.

thanks!

"Charles Kangai" <CharlesKangai (AT) discussions (DOT) microsoft.com> wrote