<div>
Is this useful?<br />
<br />
<a href="http://ora-12154.ora-code.com/" rel="ugc">http://ora-12154.ora-code.com/</a>
</div>


Is this useful?

http://ora-12154.ora-code.com/ [http://ora-12154.ora-code.com/]

<div>
<div class="content wysiwyg-content">
My 1st time trying to get ssis up and running on this server. &nbsp;Creating the connection gives me an erro ora-12154 ' could not resolve the connect identifier specified '.<br />
<br />
I have a tnsnames.ora file setup and am using that with other applications. &nbsp;Someone else setup the sql server and I'm a bit leery making many changes until i know what I'm doing.<br />
<br />
any help would be appreciated. &nbsp; &nbsp;The project by the way is scheduling passing a sql server table to oracle 10.2g.. &nbsp; SHould be a good training project but I need it now!<br />

</div>
</div>


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!


My 1st try setting up ssis on sql server r2

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.