• Status: Solved
  • Priority: Medium
  • Security: Private
  • Views: 47
  • Last Modified:

SSIS 2008 connecting to Oracle

I need to create a package variable or expression for the oracle connection. I have already changed the setting to be 32bit dubug mode. I am told that in order to connect to oracle with 64 bit SSIS \ BIDS, the connection needs to be done via an expression. I don't know how to do that, can somebody provide a good URL that shows me how to do this with exmaples?

Thanks experts!
0
sqlagent007
Asked:
sqlagent007
  • 2
2 Solutions
 
DcpKingCommented:
After doing a little research and asking around, someone pointed me at this:

http://sqlblog.com/blogs/jorg_klein/archive/2011/06/09/ssis-connect-to-oracle-on-a-64-bit-machine.aspx

This guy appears to have solved a problem remarkably like the one you're describing.

hth

Mike
0
 
SThayaCommented:
Hi ,

  Your connection string should be like this

Syntax:
Data Source=SERVICE NAME;User ID=Oracle Username;Password=[valid password];Provider=MSDAORA.1;Persist Security Info=True;

Example Dynamic Connection string  for SQL Server . please change in to your way

steps:

create variables for datasource,userid,password with a data type of string and write the expression as like below with above syntax

"Data Source="+  @[User::Desti_server]  +";User ID="+ @[User::Desti_UName] +";Password="+ @[User::Desti_Pwd] +";Initial Catalog="+ @[User::Desti_DB] +";Provider=SQLNCLI10.1;Persist Security Info=True;Auto Translate=False;"
0
 
sqlagent007Author Commented:
Thank you so much! We now have working packages. I appologize for the delay.
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now