SQL 7 SP4 MDAC 2.7 schedule DTS package won't run

• kwisley

  Newbie

  Points: 3

  More actions

  October 22, 2003 at 7:37 am

  #160889

  I installed SQL 7 SP4 and MDAC 2.7.1 last week. Since that install, none of my scheduled DTS packages will run. All packages ran fine prior to this install. Any thoughts on what I need to do? I can execute the packages from the server and the client using DTSrun at a command prompt, I can also execute the packages from DTS designer on both the server and the clients.

• October 27, 2003 at 12:00 pm

  This was removed by the editor as SPAM

• robinhc

  SSCommitted

  Points: 1617

  More actions

  October 30, 2003 at 3:08 pm

  #480372

  Check the ownership of the jobs that are created when you scheduled the DTS Packages. Look at the job history for error messages.