I am developing on a test system and I want to transfer several of my files
to another test system (at home).

Can you transfer a DTS Package from one server to another?

Export does not have a utility to select a Package.

Any assistance will be greatly appreciated. I would hate to have to
re-write my packages.


Thanks

You have a number of options

1. Backup MSDB
2. Export msdb..sysdtspackages
3. Save as a Structured storage file
4. Save as VB


--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Doug Gifford" <doug.gifford (AT) cox (DOT) net> wrote

In message <#W9UNTj5DHA.3308 (AT) TK2MSFTNGP11 (DOT) phx.gbl>, Allan Mitchell
<allan (AT) no-spam (DOT) sqldts.com> writes

Some more info on some of these methods-

Transferring DTS Packages
(http://fatcat/sqldtsnet/default.aspx?204)
--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

Darren,

The link you provided below doesn't work. Looks like an intranet link. Can
you please repost the corrected one?

Thanks,

Matt Childs

"Darren Green" <darren.green (AT) reply-to-newsgroup-sqldts (DOT) com> wrote

Darren meant

Transferring DTS Packages
(http://www.sqldts.com/Default.aspx?204)

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Matt Childs" <matt_childs (AT) yahoo (DOT) com> wrote

In the package editor perform a "Save AS" and choose
Structured Storage File. This will allow you to move the
package around like a file. Once you are ready to re-open,
right click on the DTS tree level and choose to open a
package. Once there save as a SQL Server Loacation.

James