I am trying to migrating a SQL server from a Windows 2000
server to a Windows 2003 Server. I can easily copy
(Import/Export) all the objects such as store procedures,
tables, views, etc.

But in the source server(Windows 2000), there are about 20
DTS local packages. I want to have these package
themselves transferring to new server without creating
these DTS packages from scratch in the new server.

How to accomplish this?

Thanks very much in advance.

You can find a few ways to do this explained in the article,
Transferring DTS Packages, on sqldts.com:
http://www.sqldts.com/default.aspx?204

-Sue

On Thu, 20 May 2004 14:43:30 -0700, "jonathan.cao (AT) nacalogistics (DOT) com"
<anonymous (AT) discussions (DOT) microsoft.com> wrote:

Sue,

Thanks very much for information.
Now I will do the exactly same things to jobs: how can I
transfer jobs from one SQL server to another?

Are jobs automatically transfered after transfering the
DTS local packages?

Jonathan

In message <feb401c43eb8$2bdee8f0$a101280a (AT) phx (DOT) gbl>, Jonathan
<anonymous (AT) discussions (DOT) microsoft.com> writes
You can manually script jobs, or script them through SQL-DMO, or there
is a transfer jobs task in DTS (SQL 2000 Only).


--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

I found an even easier way:
1. Ensure that the old and new servers are defined in your 'Enterprise Manager'
2. Open the DTS package on the existing server in the 'Design View'.
3. From the 'Package' menu, click on 'Save as...'.
4. Select the 'Server' name from the Server drop down box you want to move the DTS package to.
5. Click on 'Ok'.

This will move the DTS package from one server to the other. Hope it helps!!! - Eric -


"Sue Hoegemeier" wrote: