Tuesday 3 July 2012

SSIS - Error Column "XXX" Cannot convert between unicode and non-unicode string data types

When building an SQL Server Integrastion Services package to import data from AS400 Database to SQL Server 2008 database I receive an error

"Error Column "XXX" Cannot convert between unicode and non-unicode string data types"



Create data conversion specify column, add new column alias (i.e. new column name).  Be sure to specify enough length.




Afterwards remap to new Output alias in the destination

No comments:

Post a Comment