October 6, 2011 at 9:54 am
Hello, I hope someone with more experience can help.
I am trying to use SSIS to move non unicode data into an Oracle database where it will stay as non unicode. The problem I am having is that somewhere between the source and destination, the data is changed to unicode and subsequently fails when it comes to inserting the data into Oracle. I'm I doing something wrong, is there a way around this?
Thanks for reading,
D.
October 6, 2011 at 10:18 am
Duran (10/6/2011)
Hello, I hope someone with more experience can help.I am trying to use SSIS to move non unicode data into an Oracle database where it will stay as non unicode. The problem I am having is that somewhere between the source and destination, the data is changed to unicode and subsequently fails when it comes to inserting the data into Oracle. I'm I doing something wrong, is there a way around this?
Thanks for reading,
D.
Hi,
I don't think your problem is with unicode/non-unicode data. I transfer data to Oracle without any issues, or having to convert it to unicode.
My suspicion is that the problem lies with incompatible data types. Create a destination table in Oracle with varchar fields only, and convert all your source columns to varchar too before transferring...and see if that succeeds.
If that doesn't work, please post more information so that we can help you better. We'll need some test data and also table scripts of both your source and destination.
Hope this helps.
October 6, 2011 at 7:42 pm
I've seen that ssis converts text to unicode, IIRC the solution is just that you have to use a Conversion task to explicitly change it to the correct type.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply