Solved

My 1st try setting up ssis on sql server r2

Posted on 2011-02-17
2
399 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 500 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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

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 …
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.
Hi friends,  in this video  I'll show you how new windows 10 user can learn the using of windows 10. Thank you.

862 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now