You are here: Unicode Conversion « MsSQL Server « IT news, forums, messages
Unicode Conversion

Posted by JayCallas on 01/09/06 21:04

I have created an SSIS (think that is what DTS is called now) package
to run on a SQL 2005 server. It's job is to connect to a SQL 2000
server, execute a stored procedure, and insert the returned data into a
table of the '05 box.

In both tables (source and destination), the string columns are defined
as VARCHAR. But when I run my package, i get back the following error
'Column "xxx" cannot convert between unicode and non-unicode string
data types'.

While they DO have different collation values --
SQL_Latin1_General_CP1_CI_AS on sql 2000 database and
Latin1_General_CI_AI on the sql 2005 database (columns are set to use
database default value) -- it was my understanding (or
mis-understanding) that collation values do not affect unicode issues.

Is there anything I can look at to further find the problem or even fix
it?

Thanks,

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация