Question marks appear instead of arabic characters after data migration between sql server and oracle!!

Hi all,
i'm using SSIS to migrate data from an SQL Server DB to an Oracle DB, everything goes fine except the question marks that appear instead of the arabic characters when data is moved to the oracle tables!!

NLS_Lang entry in the oracle DB is:
AMERICAN_AMERICA.AR8MSWIN1256

NLS_Lang entry for the oracle client thats on the SQL Server is exactly the same, any suggestions?!

thanks alot in advance !

farahwjAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

farahwjAuthor Commented:
NLS_NCHAR_CHARACTERSET for the Oracle DB is: AL16UTF16
 
0
HoggZillaCommented:
In SSIS you can choose the Column Code Page for each connection. Have you done this? What did you choose for SQL Server, for Oracle?
Here is a Transform tool from MS. http://www.microsoft.com/downloadS/details.aspx?FamilyID=9e56417e-23d1-4fd3-8d6d-61314faa2de3&displaylang=en
Another good reference for this issue:
http://www.microsoft.com/globaldev/reference/WinCP.mspx 
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
farahwjAuthor Commented:
>>In SSIS you can choose the Column Code Page for each connection. Have you done this? What did you choose for SQL Server, for Oracle?
how??
0
farahwjAuthor Commented:
i have downloaded and installed the tool successfully but i still need your help with using it, i have the following 2 test tables:
a table named groups in sql server and it has the following structure;
id                      nvarchar(50)
arabicdesc     nvarchar(200)
englishdesc   nvarchar2(200)
ABRV                nvarchar2(50)
flag                    int
 
the equivalent oracle table is as follows:
desc groupstest
 Name                                                  Null?    Type
 ----------------------------------------------------- -------- ----------------
 CODE                                                           NVARCHAR2(50)
 EDESC                                                          NVARCHAR2(200)
 ADESC                                                          NVARCHAR2(200)
 ABRV                                                           NVARCHAR2(50)
 FLAG                                                           NUMBER(1)
 
in your reply you stated that i can choose the Column Code Page for each connection
, i didnt know from where!!
how can i use the tool with these 2 tables i described above?
 
 
0
farahwjAuthor Commented:
ok it worked, i put  code page 1256 for both the sql server connection and the oracle connection, and same to CodePageConvert tool and set its converttounicode property to false :) thanks alot HoggZilla!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.