Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2002
    Location
    Singapore
    Posts
    71

    Unhappy Unanswered: 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


  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    Which service pack are you using with your sql server 7 ? What was your recovery process - did you have to reinstall sql server ?

  3. #3
    Join Date
    Jun 2002
    Location
    Singapore
    Posts
    71
    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

  4. #4
    Join Date
    Jun 2002
    Location
    Singapore
    Posts
    71
    Hello All.

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


    Best regards
    Teck Boon

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •