Trying to import oracle data via sql server ssis
Posted on 2011-09-26
I'm trying to set up an ssis package to collect some data from some oracle tables. A few of the columns in the resulting query show up as System.Byte (with a trailing square). The data type on the oracle side is RAW (16) and shows as a 16 byte hex number when I view the data through toad (i'm a newbie with oracle).
The SSIS connection manager shows the provider as Native OLE DB\Microsoft OLE DB Provider for Oracle, but, I've also tried Native OLE DB\Oracle Provider for OLE DB. Both get the same result.
Any thoughts on how I can get the data to show up as 16 byte hex?