Error with Unicode on Data source
Posted on 2011-10-18
I have a SSIS package that connects to an Oracle Database source and and SQL 2008 destination. It basically does a SQL task to truncate the table in SQL server and then does a full dump of the table from Oracle. (Refreshing the SQL table from Oracle source).
Anyway, I can do this manually, but decided to make a SSIS package since we want to allow users to trigger it.
The problem I have is that when I set up the Data Source (SOURCE!!!!) I get an error:
Column _____ cannot convert between unicode and non unicode string data types"
Note this error is BEFORE I even connect the source to any destination.
I understand that when that error is on the destination that I could use a data conversion to get it from one type to the other, but this does not work when the error is on the source - BEFORE connecting to any destination. Any idea what is going on????