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 execution

Is there a method to either:
A) Kick of a DTS package directly from a stored procedure without shelling out to the DTSRun facility.
B) Kick off a scheduled job containing a DTS task from a stored procedure?
What's the best method?Choose option as stated in this KBA http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q269074 to schedule DTS as a job.|||Thanks Satya. Good info.

DTS Import Update table.

HI.. My name is Raman
I am the beginner in using DTS Import facility.

Can any one help me how to update the table while importing the Execl file using DTS import wizard
I imported an Excel Files that files having three records .I wont import once again same e file, which is modified in Excel file. Once I import one more files with same fields that should be updated. Instead of deleting or appending to the same table
plz any one can help me in this regard.Selecting "Delete rows in destination table" of "Column Mappings" tab in "Column Mappings and Transformations" page will solve your problem. To get to this page click "..." below "Transform" in "Select Source Tables and Views" page.|||No dear if i do like that.it will deletes all the rows and it will insert once aggain.i dont wont to do like that.just i need to update the table.
ok finally i come to know that there is no update table statement in DTS import option is it true??
ok any how thanx for u r replay byee..
Raman :)