Lost DTS package? Default storage location?

• John King

  Say Hey Kid

  Points: 705

  More actions

  June 2, 2003 at 11:31 am

  #159959

  Hi:

  Last week, my local hard disk quit working. The disk has been sent to recover whatever data is possible, and the answer to this question may change some priorities.

  At the moment, the only thing I can no longer do is import data into SQL Server tables (from DBF tables) via a DTS package that loaded and executed from an Access VB procedure.

  The error message is

  'System cannot find the file specified'

  I can see the package listed in Enterprise Manager, and I can see multiple versions of it.

  Was this package stored on my local hard disk and not in SQL Server?

  I thought it was stored on the SQL Server machine under 'Data Transformation Services' > 'Local Packages'

  Thanks for your time.

  JK

• John King

  Say Hey Kid

  Points: 705

  More actions

  June 2, 2003 at 12:05 pm

  #459403

  Hi:

  Additional information:

  If I run

  SELECT * FROM sysdtspackages

  in the msdb database

  I see the two DTS packages, only one I care about. The fields are all populated and the data looks similar to what I see in Enterprise Manager.

  However, still if I try to edit or execute, it cannot find the file speficied.

  JK

• John King

  Say Hey Kid

  Points: 705

  More actions

  June 2, 2003 at 6:59 pm

  #459444

  Hi:

  I installed SQL Server 7.0 Service pack 4 and I can now access the DTS package from the machine it was developed on.

  Thanks,

  JK