Copy DTS package

#1

Hello, all. We need to copy a DTS from one SQL Server 2K machine to another.
What's the least painful way to do this? Thanks.

#2

Found the answer -- it was too easy. I just needed to do a "Save As..." and
change the server name. Well, duh!

"dw" <cougarmana_NOSPAM (AT) uncw (DOT) edu> wrote

Quote:

Hello, all. We need to copy a DTS from one SQL Server 2K machine to
another.
What's the least painful way to do this? Thanks.

#3

In article <uBeFzA0aEHA.3204 (AT) TK2MSFTNGP09 (DOT) phx.gbl>, Dw wrote:

Quote:

Found the answer -- it was too easy. I just needed to do a "Save As..." and
change the server name. Well, duh!

"dw" <cougarmana_NOSPAM (AT) uncw (DOT) edu> wrote in message
news:%23EhE5%23zaEHA.2520 (AT) TK2MSFTNGP12 (DOT) phx.gbl...
Hello, all. We need to copy a DTS from one SQL Server 2K machine to
another.
What's the least painful way to do this? Thanks.

Glad you found the answer.

If you have a need to migrate a lot of packages then you may be able to make
use of this tool.

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

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
www.konesans.com - for all your consultancy needs

#4

Thanks, Allan. I'd visited that site a year ago or so, but forgotten all
about it. I've used a lot of code from them.

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

Quote:

In article <uBeFzA0aEHA.3204 (AT) TK2MSFTNGP09 (DOT) phx.gbl>, Dw wrote:
Found the answer -- it was too easy. I just needed to do a "Save As..."
and
change the server name. Well, duh!

"dw" <cougarmana_NOSPAM (AT) uncw (DOT) edu> wrote in message
news:%23EhE5%23zaEHA.2520 (AT) TK2MSFTNGP12 (DOT) phx.gbl...
Hello, all. We need to copy a DTS from one SQL Server 2K machine to
another.
What's the least painful way to do this? Thanks.

Glad you found the answer.

If you have a need to migrate a lot of packages then you may be able to
make
use of this tool.

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

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
www.konesans.com - for all your consultancy needs

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

Copy DTS package

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

Copy DTS package - 07-16-2004 , 09:18 AM

Re: Copy DTS package - 07-16-2004 , 09:21 AM

Re: Copy DTS package - 07-16-2004 , 10:51 AM

Re: Copy DTS package - 07-16-2004 , 11:32 AM