February 27, 2002 at 1:43 pm
I have created a DTS package that will routinely pull data from an Oracle server (using the ODBC connection). When I run the package manually I get data, but if I try to schedule the package I receive no data. The package contains the odbc connection with my personal login and pword. I think that the SQL server agent is having difficulty logging into oracle because it is not using my login. How can I schedule the package to get data?
March 1, 2002 at 6:19 am
I actually found a way to get this to work. Of course you should need to have Oracle client on the server running the package, but instead of using the MS oracle ODBC connection I experimented with the MS OLE DB Provider for Oracle--THIS WORKED. The only issue that I have is that in the job the history (using SQL 7.0) states that no output was returned when output has been created. Not sure how to resolve that, but if anyone has an idea. I would appreciate it.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply