I am working on an SSIS project, to pull data from Oracle 10.2g into SQL Server 2008R2, 64-bit. This project was running fine on a 32-bit SQL 2008 database, but after moving it to the new 64-bit server, I am getting this error:
Description: Column "XXX" cannot convert between unicode and non-unicode string data types.
End Error Error: 2012-03-09 11:01:03.31
This package runs fine on the server inside Visual Studio, but when I put the dtsx file in the SQL Agent job, I get these errors all the time. I have added the Data Conversion to this, but it does not help with the error when run as a SQL Job. I have searched everywhere, and cannot find a fix.
Can someone help me?