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!