Problem encountered AFter apply SP4

• Ollie Steele

  SSC Enthusiast

  Points: 185

  More actions

  July 10, 2006 at 8:06 am

  #97200

  After applying service pack4 on SQL2000 test server we experienced problem in running jobs through enterprise manager on the DTS step.  The messsage received from DTS failure is:

  1)Error: -2147220460 (80040414); Provider Error: 0 (0) Error string: Cannot find specified package in the storage location specified. Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 713  OR

  2)Error: -2147220455 (80040419); Provider Error: 0 (0) Error string: Access to package properties requires entry of package owner password. Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 713

  DTS step runs successfully if manually ran.

  Has anyone else experienced this problem or have any suggestions?

  Thanks

   

   

   

   

• David A. Long

  SSCrazy Eights

  Points: 8421

  More actions

  July 11, 2006 at 1:53 am

  #648378

  I had to delete the DTS scheduled Jobs and reschedule the DTS Jobs to correct.

  I documented the settings and rescheduled using EM as I only had 4 jobs to fix.

  I was never sure what caused this but it was "near" sp4 update.

  Andy