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,

[Back to original message]