Hello,

I have made some DTS package that I need to replicate my DTS packages at
another machine.
How can I do this?

I created these packages using Enterprise Manager of SQL Server 2000
Enterprise Edition. I understand that you can save the DTS packages a VB
..bas file, Structure file or in SQL Server DB itself. But how can I create
DTS packages out of any of these 3 formats?

Thanks.

If you are looking to move a DTS job from one server to another, then as you
mention, you can first save it to a structured file format. Then, you can
open that structured file format in the other server, and save it as a local
package.

Opening the file in the other server goes as follows:
right-click Data Transformation Services (on the server where you need the
DTS job to be)
click Open Package
use the browser to surf to wherever you have the package stored, in
structured file format
this could even still be back on the original server where you built the
package, depending on how your network is set up
click on the package file you want
choose the version you want (you may have multiple versions of that package,
depending on what you've been up to)
now the package is open on the other server
on the menu, click Package | Save As
in Location, choose SQL Server
you'll need to set the servername, username, and password
click OK
once you've got it saved, you may need to edit global vars or other settings
depends on what you've been up to
it might be better to do that sort of editing prior to moving the package,
using the "disconnected edit" feature


"Kasp" <kasp (AT) NO_SPAMepatra (DOT) com> wrote

Have a look here

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

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
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


"Kasp" <kasp (AT) NO_SPAMepatra (DOT) com> wrote

Thanks for the solutions guys.