avoorheis
asked on
Trying to import oracle data via sql server ssis
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?
thanks
alan
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?
thanks
alan
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.