rwheeler23
asked on
SSIS Cannot convert between unicode and non-unicode string data types
This is using SQL Server 2012 SSIS. I am converting an SSIS project from SQL Server 2008 to 2012. There is a set of variables that need to be converted prior to import. I convert them to Unicode string([DT_WSTR) 50 and 200 which exactly matches what is in the table. I have looked at the column matching all the way through and they are correct. I still cannot get past this message: "SSIS Cannot convert between unicode and non-unicode string data types"
Any suggestions on what I can try to get this to work?
Any suggestions on what I can try to get this to work?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks. This explains what was going o behind the scenes.
ASKER