Link to home
Start Free TrialLog in
Avatar of avoorheis
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
ASKER CERTIFIED SOLUTION
Avatar of lcohan
lcohan
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial