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?