Whats the best way to move all packages to another server? Ive got hundreds
to move and the only thing I know is ...Open Packages..Click Package..Save
As

Thnks
JL

JL,

Look into the Deployment Utility

(SQL BOL item:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/extran9/html/354322a4-ae8c-4d92-8e71-42d29dbd0614.htm)

or the Package Migration Wizard

(SQL BOL item:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/extran9/html/a104407e-2026-4c42-80ff-d44f30d598cb.htm).

Hope this helps,
Patrik

--
This posting is provided "AS IS" with no warranties, and confers no rights.
"JL Morrison" <sqlserverdba (AT) tampabay (DOT) rr.com> wrote

Hello JL,

A lot of people like to use this

http://www.sqldts.com/default.aspx?204


Allan

I just want to clarify, this is for SQL 2000. The migration does not work
on almost all of our packages and I need to move them somewhere while I
rebuild the server with SQL 2005.


"JL Morrison" <sqlserverdba (AT) tampabay (DOT) rr.com> wrote

Thanks! Saved me a day of work. Now I can play more Bejeweled!

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