How move dts

#1

I am moving to a new machine. On my old machine I have a single user SQL
Server 2000 installed and it has some packages. I have installed SQL server
on the new singele user machine and it does not have these packages. Is
there a way to get the packages on machine A moved to machine B?

#2

Yes - in SQL Server 2000 there is a feature that when you
do a 'SAVE AS' for your DTS package you can create the
script. The script can then be used to create the
package on your new server.

Quote:

-----Original Message-----
I am moving to a new machine. On my old machine I have
a single user SQL
Server 2000 installed and it has some packages. I have
installed SQL server
on the new singele user machine and it does not have
these packages. Is
there a way to get the packages on machine A moved to
machine B?

.

#3

Allan

When I click on the link you suggested I get a "Page not found"

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Quote:

I think you are referring to "Save As" VB Module not a script per se.

Have a look at this

Transferring DTS Packages
http://www.sqldts.com/default.aspx?6,105,204,0,1

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"peg" <pegnmil (AT) msn (DOT) com> wrote in message
news:054101c35aed$d4065680$a601280a (AT) phx (DOT) gbl...
Yes - in SQL Server 2000 there is a feature that when you
do a 'SAVE AS' for your DTS package you can create the
script. The script can then be used to create the
package on your new server.

-----Original Message-----
I am moving to a new machine. On my old machine I have
a single user SQL
Server 2000 installed and it has some packages. I have
installed SQL server
on the new singele user machine and it does not have
these packages. Is
there a way to get the packages on machine A moved to
machine B?

.

#4

In article <#jAEIe2WDHA.1512 (AT) TK2MSFTNGP11 (DOT) phx.gbl>, Woody Splawn
<woody (AT) splawns (DOT) com> writes

Quote:

The script can then be used to create the
package on your new server

Could you elaborate a little on how this is done?

As Allan said the Save AS VB option is not a script in the SQL sense,

but a VB module. You will need to open this in VB, add references to the
DTS libraries in your VB project, change the SaveToSQLServer option at
the bottom to match your destination and then run/compile the VB code.

This can help "migrate" packages when properties need changing, but you
don't need to go through the VB code stage to do this. You can write a
VB program to do the transfer between servers directly, "migrating"
properties as it goes. (Sample linked from the article).

Why not just do Save As and select your destination server as the new
location? For a lot of packages take a look at the article Allan posted
a link to as this will save a lot of time.
--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

How move dts

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

How move dts - 08-04-2003 , 06:48 PM

transfering 2000 packages - 08-04-2003 , 08:06 PM

Re: transfering 2000 packages - 08-05-2003 , 10:39 AM

Re: transfering 2000 packages - 08-06-2003 , 03:13 PM