"Invalid Instance" error when running DTS 2000 package

• Aimee Rodgers

  SSC Rookie

  Points: 37

  More actions

  July 20, 2007 at 6:59 am

  #69364

  Our machine is running SQL Server 2005.  We have a job that runs nightly and calls a legacy DTS 2000 package.  (We are not upgrading this package to SSIS for now.)

  The DTS package being called references an .ini file with the database\instance name.  Everything looks correct, but when the job gets to this point in the DTS package, the job fails and returns the following error:

  DTSRun OnError: DTSStep_DTSExecuteSQLTask_1<c/> Error = -2147467259 (80004005) Error string: [DBNETLIB][ConnectionOpen (Invalid Instance()).]Invalid connection.

  Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0 Error Detail Records: Error: -2147467259 (80004005); Provider Error: 14 (E) Error string: [DBNETLIB][ConnectionOpen (Invalid Instance()).]Invalid connection. Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0 DTSRun OnFinish: DTSStep_DTSExecute... Process Exit Code 1. The step failed.,00:00:17,0,0,,,,0

  We have tried everything we can think of.  The system has the right permissions, the db\instance is correct.  Does anyone know what else we should look for?  Thanks!