Re: copy DTS design package from one server to another

#1

Options range from a simple Save As in Enterprise Manager through to more
automated methods.

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

--
Darren Green
http://www.sqldts.com

"Hong Wang" <HongWang (AT) discussions (DOT) microsoft.com> wrote

Quote:

Hi,

I have to move a couple of databases from one server to another. There are
some DTS packages associated with the databases. Is there a simple way to
copy the DTS packages from one server to another, instead of re-design the
whole package again?

Thanks.

#2

You can move all or couple of databases at a time by using CDW(Copy Database
Wizard).Just right click on database under enterprise manager and click on
all tasks there u can fine copy database wizard or u can select it from
tools menu wizards and expand management and select copy databse wizard.Just
gothrough the wizards so that u can understand easily

"Hong Wang" wrote:

Quote:

Hi,

I have to move a couple of databases from one server to another. There are
some DTS packages associated with the databases. Is there a simple way to
copy the DTS packages from one server to another, instead of re-design the
whole package again?

Thanks.

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

Re: copy DTS design package from one server to another

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

Re: copy DTS design package from one server to another - 08-16-2004 , 09:37 AM

RE: copy DTS design package from one server to another - 09-20-2006 , 11:26 AM