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
:)

DTS Packaage Password Recovery

We recently had an employee leave under bad terms that left refusing to give up the passwords to about 20 DTS packages. Does anyone know how to recover DTS package passwords? Utility??
I need to do this as soon as possible since some of the connection passwords will expire within 30 days and must be updated.

ShadarSorry - none exists.|||As a SA login you can access the DTS packages and set desired password.

Follow this
similar thread (http://dbforums.com/arch/227/2002/5/903300) for information.

HTH|||The link in the previous email was bad. Can anyone give me more detail on this?