Solved

My 1st try setting up ssis on sql server r2

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

Free Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

Join & Write a Comment

Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
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…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

747 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

12 Experts available now in Live!

Get 1:1 Help Now