Check this link and make sure you have followed all the steps, including enabling “Allow inprocess” for the OraOLEDB provider:
http://www.ideaexcursion.com/2009/01/05/connecting-to-oracle-from-sql-server/[/url]
Bad_Karma (5/9/2012)
Well, thats what I attempted to do when I created the ETL account, but it's not working. I can only hit the linked directly when logged directly into Mgmt Studio with my windows account. I even tried running the job as my windows account and that doesn't work either.
_________________________________
seth delconte
http://sqlkeys.com