Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
itsmsca
Starting Member
3 Posts |
 Posted - 2008-08-24 : 11:52:30
|
I am using SSIS packagees to load data into SQL Server tables. The data is first imported via SNA link on a pre configured HIS server. On the Host (mainframe) side all data is in flat file format with arabic/latin mixed columns. The problem is that after I execute my packages only the arabic data is all incorrect (garbage). I am using code-page 1256 in OLE DB Destination connection properties for the packages. Any clue?  |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-08-24 : 13:56:46
|
| What's the destination column type? Whats the collation used? does it support arbic characters? |
 |
|
|
itsmsca
Starting Member
3 Posts |
Posted - 2008-08-26 : 09:23:51
|
quote:
Originally posted by visakh16
What's the destination column type? Whats the collation used? does it support arbic characters?
The dest columns are CHAR, and no collation is applied. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-08-26 : 10:19:05
|
quote:
Originally posted by itsmsca
quote:
Originally posted by visakh16
What's the destination column type? Whats the collation used? does it support arbic characters?
The dest columns are CHAR, and no collation is applied.
whats the default collation of db? does it support arabic characters? |
|
|
|
|
|
|
Arabic data problem