My 1st try setting up ssis on sql server r2

My 1st time trying to get ssis up and running on this server.  Creating the connection gives me an erro ora-12154 ' could not resolve the connect identifier specified '.

I have a tnsnames.ora file setup and am using that with other applications.  Someone else setup the sql server and I'm a bit leery making many changes until i know what I'm doing.

any help would be appreciated.    The project by the way is scheduling passing a sql server table to oracle 10.2g..   SHould be a good training project but I need it now!
tdssoftwareservicesAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
tigin44Connect With a Mentor Commented:
I think you are facing 32 /64 bit driver problem. SSIS uses 32 bit oracle drivers at design time and 64 bit oracle  drivers at runtime on a x64 box. So these links may halp you...

http://blogs.microsoft.co.il/blogs/bilive/archive/2011/01/16/oracle-driver-installation-for-ssis-2008-r2.aspx

http://www.ssas-info.com/analysis-services-articles/63-connectivity/2111-oracle-driver-configuration-for-ssis-ssrs-and-ssas-in-a-64-bit-environment
0
 
mcv22Commented:
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.