I receive error ORA-12154: TNS could not resolve the connect identifier specified when trying to setup a datasourec within BIDS. Strange here is that the creation of a linked server to the same Oracle db is working, also importing data from the Oracle db works perfectly; but when saving the import as a package, I get the same error when running the package in BIDS. I run everyting on my local workstation which is 32 bit. Thanks for any help

what is the provider u are using ??? do u have oracle client 32 bit installed ? and are the tns name ora entries correct ??Hope that helps ... Kunal

i agree with Kunal's thrid point because if you are receiving 'TNS could not resolve the connect identifier specified' error it means that you are able to use oracle but some thing is wrong with your TNS entries, please check that.

TNS entries seems to be ok. If there was a problem with TNS, how would the Import process or the linked server setup know where to find the Oracle db?

Just to be sure, can you validate with SQL*Plus that the TNS you are using is working? Do you also have multiple Oracle client NETWORK directories installed per chance? Please provide the client you are using like requested. It will make a large difference in determining the root causeTed Krueger Blog on lessthandot.com @onpnt on twitter Please click the Mark as Answer button if a post solves your problem!

When issuing the command: sqlplus user1/pwd1@TESTDBA I receive following error: SQL*Plus: Release 9.2.0.7.0 - Production on Thu Nov 4 13:40:16 2010 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. ERROR: ORA-12154: TNS:could not resolve service name Enter user-name: When I enter username and password again, following error is given: Enter password: ERROR: ORA-12560: TNS:protocol adapter error We do have different NETWORK directories installed: C:\Program Files\ORANT7 C:\Program Files\ORANT8 C:\Program Files\ORANT9 This is the enty in all TNSNAMES.ORA files: TESTDBA.WORLD = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = unorad1.eib.electrabel.be) (PORT = 1529) ) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = TESTDBA) ) )

I managed tosolve the issue myself; there was an system environment variable that pointed to a central TNS folder. By changing the location to a local TNSNAMES.ORA folder, SQLPLUS as well as SSIS worked fine. However, how the linked server and the Import features worked, is a mystery to me. Thanks all for your help, appreciate it