all groups > sql server dts > august 2003 >
You're in the

sql server dts

group:

How do you transfer a DTS package between Servers ??



How do you transfer a DTS package between Servers ?? les
8/30/2003 1:57:00 PM
sql server dts: I tend to search for answers before posting new ones, but
searching for "Transfer DTS Packages" yields too much.

So, how do I transfer DTS packages themselves between SQL
2000 servers ??

Thanks,

Re: How do you transfer a DTS package between Servers ?? Allan Mitchell
8/30/2003 9:36:02 PM
How about this

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


--


Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
Re: How do you transfer a DTS package between Servers ?? matthew larson
9/2/2003 10:59:23 AM

Trying saving your dts as a .dts file when you chose save as
you will see a Location Combo box you can select structured storage
file. This creates you filename.dts file you can then copy to you other
server and reopen from the other server and save to that server.

Or if you have both servers in your Enterprise manager you can select
which server to save to from the same place as selecting structured
storage file.

*** Sent via Developersdex http://www.developersdex.com ***
AddThis Social Bookmark Button