Best way to convert non unicode to unicode when importing data
Hi all, I was wondering which is the best way to convert data between non unicode and unicode characters. For instance, I'm importing data from an Oracle db and loading it into an SQL server 2008R2. Any suggestion is really appreciated! Thanks in advanced, Gabriel
July 19th, 2011 6:43am

I prefer the CAST in the source query (so you don't get a lot of extra columns). Other options are the derived column: (DT_STR, «length», «code_page»)[YourColumn] Or use the Data Conversion transformation Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com
Free Windows Admin Tool Kit Click here and download it now
July 19th, 2011 6:51am

Hi all, I was wondering which is the best way to convert data between non unicode and unicode characters. For instance, I'm importing data from an Oracle db and loading it into an SQL server 2008R2. Any suggestion is really appreciated! Thanks in advanced, Gabriel Joost has given you a few options. Really, there is no "best" way - its up to YOU to decide which works best for YOU.http://sqlblog.com/blogs/jamie_thomson/ | @jamiet | About me
July 19th, 2011 7:59am

Thanks a lot for your reply, really useful. Gabriel
Free Windows Admin Tool Kit Click here and download it now
July 19th, 2011 11:15am

I prefer the CAST in the source query (so you don't get a lot of extra columns). --CAST (ANSI standard) SELECT CAST(someColumn AS nvarchar(50)) AS someColumn FROM someTable --CONVERT (Microsoft specific) SELECT CONVERT(nvarchar(50), someColumn) AS someColumn FROM someTable Other options are the derived column: (DT_STR, «length», «code_page»)[YourColumn] Or use the Data Conversion transformation Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com
July 19th, 2011 1:41pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics