accessing Oracle data with dts

• Jp

  Default port

  Points: 1419

  More actions

  April 7, 2006 at 6:22 am

  #112801

  Hi,

  I have a dts pkg that connects to Oracle8i and loads data into one of sql database.Before it truncates the sql tables.I have created DSN using Oracle for OraHome92 driver.The DSN is on my local machine and on the sql server also.

  When I run the pkg from EM on my machine or from the server, it works fine but when It is scheduled to run as a job,It can't pass the truncate step which is the 1st in the dts pkg.

  Any idea why this is happening?

  Thanks,

  JP

• Antares686

  SSC Guru

  Points: 125444

  More actions

  April 7, 2006 at 12:24 pm

  #631578

  What account is SQL Agent running under. I have had this issue with Oracle myself because the account has to hav rights to use the driver.