SSIS package creation [message #652165] |
Fri, 03 June 2016 02:34 |
pstanand
Messages: 133 Registered: February 2005 Location: Chennai,India
|
Senior Member |
|
|
Hi,
I'm trying to create SSIS package through SQL Server Import Export Wizard.
I held up in an error that "TNS: Could not resolve the connect identifier specified".
I have my tnsnames.ora in the product\12.1.0\client_1\network\admin path.
And this path has been included in the environmental variable of my system too.
Eventhough I got this error. Could you please help me here to resolve this issue.
And let me know where I'm wrong so that I can correct and proceed further.
Thanks for your suggestion.
pstanand.
|
|
|
|
Re: SSIS package creation [message #652173 is a reply to message #652165] |
Fri, 03 June 2016 06:38 |
|
EdStevens
Messages: 1376 Registered: September 2013
|
Senior Member |
|
|
pstanand wrote on Fri, 03 June 2016 02:34Hi,
I'm trying to create SSIS package through SQL Server Import Export Wizard.
I held up in an error that "TNS: Could not resolve the connect identifier specified".
I have my tnsnames.ora in the product\12.1.0\client_1\network\admin path.
And this path has been included in the environmental variable of my system too.
Which "the" environment variable? And exactly what value?
For a walk-through explanation of this error, see: ora-12154 TNS:could not resolve the connect identifier specified
|
|
|