I had a weird error today. I had an Oracle source table, and a SQL Server Destination table, and got an error in the dataflow component for the OLE Destination. The error was for both columns for the table and was "Column [the column name] cannot convert between unicode and non-unicode string data types". All other tables in my data flow were converting just fine, so it was really a mystery.
This is the fix: in the OLE DB destination - right click and go to the Advanced Editor, go to the Input and Output Properties, click the Destination Input/External Columns. Each of the columns' data type was set to Unicode string [DT_WSTR] - I changed it to string[DT_STR], which is what the the other columns were set to. The "red x" on my destination immediately went away, and my package executed just fine!
I don't know what it was about that particular table that caused the problem...
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment