May 23, 2011 at 6:26 am
I'm running into the 'cannot convert between unicode and non unicode' error in an ssis package I'm building.
I'm right clicking the OLE DB Destination and selecting Advanced Editor and navigated to the 'Input and Output Properties page'
I change the data type for the column in question, but when I click 'ok' to save changes and close the advanced editor, the changes are reverted back.
Why aren't these being saved? I've tried to add a data conversion step, but its still getting hung up on this.
May 23, 2011 at 2:47 pm
this is probably because SSIS gets the meta data from the source. You can change it but once it re-validates it must change it back.
Besides you still need to explicitly convert this from unicode to non-unicode.
I would recommend a data conversion or derived column to explicitly cast the values.
May 25, 2011 at 8:21 am
I'd probably add a data conversion component to the data-flow to get the types sorted out.
CEWII
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply