Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

My 1st try setting up ssis on sql server r2

Posted on 2011-02-17
2
Medium Priority
?
407 Views
Last Modified: 2012-06-27
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!
0
Comment
Question by:tdssoftwareservices
2 Comments
 
LVL 12

Expert Comment

by:mcv22
ID: 34923512
0
 
LVL 26

Accepted Solution

by:
tigin44 earned 2000 total points
ID: 34932932
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

Featured Post

Learn Veeam advantages over legacy backup

Every day, more and more legacy backup customers switch to Veeam. Technologies designed for the client-server era cannot restore any IT service running in the hybrid cloud within seconds. Learn top Veeam advantages over legacy backup and get Veeam for the price of your renewal

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
This course is ideal for IT System Administrators working with VMware vSphere and its associated products in their company infrastructure. This course teaches you how to install and maintain this virtualization technology to store data, prevent vuln…
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…

927 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question