January 6, 2010 at 6:59 am
Please iam trying to transfer data from AS400 (DB2) to sql server 2008 using SSIS , but some tables contains unicode (arabic characters), when iam transfer these tables the arabic words doesn’t seems true , how could I transfer the arabic characters in correct way?
January 6, 2010 at 8:58 pm
Arabic is right to left language so you need to define your columns as Nvarchar and Nvarchar(max) then you use Arabic table and column collation and in your execute SQL task code you can use Arabic in your expression. Here is detailed implementation from Microsoft so post again if you still need help.
http://msdn.microsoft.com/en-us/library/cc295829(SQL.90).aspx
Kind regards,
Gift Peddie
January 10, 2010 at 11:10 am
sorry, but the problem in ssis itself before pulling the data to sql server,
when i make preview data , the data is shown corrupted.
January 10, 2010 at 11:24 am
pico9 (1/10/2010)
sorry, but the problem in ssis itself before pulling the data to sql server,when i make preview data , the data is shown corrupted.
SSIS comes with data types defined to accept unicode and you can add the Arabic collation to your T-SQL DML you consume in execute sql task so I don't see how SSIS is the problem. The problem is you not using the correct collation and writing the code needed to transfer Arabic in AS400 to Arabic in SQL Server.
Kind regards,
Gift Peddie
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply