Previewing greek data in DTS

[navshiv]

Hi

I am trying to pull through greek characters in a SQL table. The source is a file in an iseries and I am using ODBC to connect.

When I am in DTS, I preview the file and it comes out with incorrectly. However, I am able to import the data into an Excel file and when I preview this in DTS it comes out in greek.

I have had IBM look at the file and ODBC setup and tell me all is correct here. They say it is a Microsoft thing (surpise surprise).

Anyone got any ideas what I need to do in SQL to pull in the greek chars correctly?

Many thanks

 

[TheBugSlayer]

What is the exact order of your operation: ISeries File=>DTS, OK; DTS=>Excel, Greek?

This is something to do with Sort Order and Collation. But it would be nice if you could graphically illustrate your dataflow.

 

[navshiv]

What I am trying to achieve is to go FROM an ISeries file into SQL Server via a DTS package. This is currently producing wrong characters.

What does work is ISeries -> Excel (via ODBC) -> SQL Server (via DTS). This is not an ideal solution, I'd rather go straight from the ISeries into SQL Server rather than Excel.

Any ideas?

Thanks.