DTS Restore from a file

We have a production server and a bunch of development servers. The
Production server is located in a NOC (Network Operations Center)
facility and is physically unaccessible on a regular basis. There are
DTS packages on the production server which we'd like to pull down to
our Dev servers.

I was able to save the DTS package to a file and downloaded it to our
Dev Servers. But how in the world do I restore it?? I'm a fairly
technical guy and for the life of me, I'm not able to figure this one
out! How do I restore the DTS package which has been stored into a
..dts file?

Please help.

Thank you in advance,

-Umar.I think what you want to know is this:

Right-click on the "Data Transformation Services" FOLDER icon and select
"Open Package..." from the options. This brings up a dialog box to hunt for
your DTS file(s).

"Umar Farooq" <UmarAlFarooq@.gmail.com> wrote in message
news:1110475810.551932.46600@.f14g2000cwb.googlegro ups.com...
> We have a production server and a bunch of development servers. The
> Production server is located in a NOC (Network Operations Center)
> facility and is physically unaccessible on a regular basis. There are
> DTS packages on the production server which we'd like to pull down to
> our Dev servers.
> I was able to save the DTS package to a file and downloaded it to our
> Dev Servers. But how in the world do I restore it?? I'm a fairly
> technical guy and for the life of me, I'm not able to figure this one
> out! How do I restore the DTS package which has been stored into a
> .dts file?
> Please help.
> Thank you in advance,
> -Umar.

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