Exporting a DTS Package

Hi,
I have a Database on one server and the same Database on
another server.
One Database has a DTS Package that I need.
Can I export this DTS package to my Database that does not
have it without doing a backup of the one that has it and
restoring it to the one that does'nt?
CHi
You van save them as files and transfer , another option is to move from
sysdtspackages table in msdb database.
"C" <anonymous@.discussions.microsoft.com> wrote in message
news:0b5d01c3b3fb$5c516ff0$a401280a@.phx.gbl...
> Hi,
> I have a Database on one server and the same Database on
> another server.
> One Database has a DTS Package that I need.
> Can I export this DTS package to my Database that does not
> have it without doing a backup of the one that has it and
> restoring it to the one that does'nt?
> C|||The easiest way of moving DTS packages between servers is to Design the DTS
package on the source server and simply say Save As and specify the other
server name.
If the servers can't see one another on the network save the package to a
structured file copy to other server then open
--
HTH
Ryan Waight, MCDBA, MCSE
"C" <anonymous@.discussions.microsoft.com> wrote in message
news:0b5d01c3b3fb$5c516ff0$a401280a@.phx.gbl...
> Hi,
> I have a Database on one server and the same Database on
> another server.
> One Database has a DTS Package that I need.
> Can I export this DTS package to my Database that does not
> have it without doing a backup of the one that has it and
> restoring it to the one that does'nt?
> C|||We use both of Ryan's methods all the time and either way
is probably your best way. Using the structured file
also allows you to utilize versioning software such as
Source Safe.
One thing to remember when you move DTS packages to a new
server is to verify all of your Data Connections within
the packages, especially if you have paths specified to
text files or MS Access files.
Matthew Bando
BandoM@.CSCTechnologies (remove this).com
>--Original Message--
>The easiest way of moving DTS packages between servers
is to Design the DTS
>package on the source server and simply say Save As and
specify the other
>server name.
>If the servers can't see one another on the network save
the package to a
>structured file copy to other server then open
>--
>HTH
>Ryan Waight, MCDBA, MCSE
>"C" <anonymous@.discussions.microsoft.com> wrote in
message
>news:0b5d01c3b3fb$5c516ff0$a401280a@.phx.gbl...
>> Hi,
>> I have a Database on one server and the same Database
on
>> another server.
>> One Database has a DTS Package that I need.
>> Can I export this DTS package to my Database that does
not
>> have it without doing a backup of the one that has it
and
>> restoring it to the one that does'nt?
>> C
>
>.
>