DTS Package Error

Hello All.

My database server (MS SQL 7) crashed yesterday. After 2 days of recovery, I have managed to restore all databases in the server. All tables, stored procedures and views are in tact except for the DTS packages.

The full list (more than 50 DTS packages) was shown in Data Transformation - Local packages but when I right-clicked on "Design Package" or "Execute Package" on any of packages, an error message pops up.

Package Error
Error Source : Microsoft Data Transformation Services (DTS) Package
Error Description : The system cannot find the file specified.

Any idea what's wrong with the above? Whatever source that was needed were in place.

I need to fix this as soon as possible otherwise I will be in serious trouble. Please help me. Thanks a million.

Best regards
Teck Boon

:confused:Which service pack are you using with your sql server 7 ? What was your recovery process - did you have to reinstall sql server ?|||Yes. I have to re-installed SQL 7 (no service pack was applied) because my boot drive C crashed. I am on NT4 SP6a.

Restoration was done in this sequence:

1. Restored my 3 application databases to K Drive.
2. Restored master database to C drive.
3. Restored msdb database to C drive.
4. Restored model database to C drive

After master database was installed, I was still unable to see my DTS listing but once MSDB database was put back into he server, listing came on but see error message.

Thank you

Best regards
Teck Boon|||Hello All.

I have resolved the DTS problem by applying SQL 7 SP4 to my server.

Best regards
Teck Boon
:)