SQL SERVER - DTS

[adeola]

Hi,
I have some packages in SQL 7.0 that connect to an Oracle data source to download data into my SQL SERVER.Running these packages manually works fine, but when they are scheduled as a job, they don't run and i get no error messages.The job even says that it's executed successfully but no data is pulled down from the Oracle Data source.Please help.Thanks

Adeola

 

[tlbroadbent]

Have you looked at the run history detail? Sometimes, it contains info that helps determine what happened.

You can create a log of the run. Open the Job properties. Click on the Steps tab. Edit each Step. Click on the Advanced tab for each step and fill in the Output file box. Close and let the Job run. Check the output file for Job run info. Terry Broadbent

"The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge." - Daniel J Boorstin