Oledb to Oracle Changes Data Type

Question

Oledb to Oracle Changes Data Type

Viewing 5 posts - 16 through 19 (of 19 total)

You must be logged in to reply to this topic. Login to reply

Mark Lanio SSC Rookie Points: 29 More actions · Answer 1

Well if nothing else, you've just introduced me to the world of Business Intelligence Studio. After I mopped up my brain, I gotta admit that this is pretty cool stuff. I think I can make what I need in here and get by. I'll play with it. Thanks for the direction!

Kevin Shen SSC Rookie Points: 41 More actions · Answer 2

Hi friends,

can you let me know where did you get 10g OLEDB driver ?

Thanks

Kevin

Kevin Shen SSC Rookie Points: 41 More actions · Answer 3

Where do you find OLE DB provider driver, I am seach, but cannot found one.

Tahnks

Kevin

Mark Lanio SSC Rookie Points: 29 More actions · Answer 4

I just installed the oracle client on my machine (and the machine that needed to run the package) and created a connection to it using the connection manager in Oracle. Then BIS was able to connect to it using Oracle connections.

malkit.rooprai SSC Enthusiast Points: 175 More actions · Answer 5

Jamie

Where do you set this property on SQL Server 2005, I cannt seem to find it anywhere. I can see DefaultCodePage