DTS Step Error code: 80004005

• GF

  Hall of Fame

  Points: 3774

  More actions

  November 14, 2007 at 3:12 pm

  #69205

  I have a DTS package that is scheduled to run each night.

  This package has been running for over 2 years with no problems. Recently, I have been getting random job failures.

  I checked the package log and on the failed steps I get the following error.

  Step Error Source: Microsoft OLE DB Provider for SQL Server

  Step Error Description:Attempt to fetch logical page (1:462458) in database 'MyDB' belongs to object 'Company_Download', not to object 'DCXIEAN_output'.

  Step Error code: 80004005

  Step Error Help File:

  Step Error Help Context ID:0

  I ran the following:

  dbcc checkdb ('MyDB',REPAIR_REBUILD ) with ALL_ERRORMSGS

  Messege returned: CHECKDB found 0 allocation errors and 0 consistency errors in database 'MyDB'

  I am using SQL2000 with sp3.

  Any help is always appreciated.

  Thanks

  Gary