DTS packages on new SQL Server

We're building a new W2K server with the same name as the current one. We
are taking down the old server, moving all the datafiles to the new server,
installing SQL Server, Analysis Services and sp3. The last time we did this
we lost our DTS packages. Can I export them somehow and then import them?
Are they not stored in the system tables?
Thanks,
DougThey are stored in the MSDB database, but moving that database is always
trickey. You can load the DTS packages into Enterprise Mangler and save
them to the file system. You can then reload and resave them when the new
server is ready. If you have a lot of packages, you can write a script to
do that automagically using SQL-DMO and the Package2 object.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Doug Stiers" <stiers@.email.com> wrote in message
news:ehNaTDFDEHA.2308@.tk2msftngp13.phx.gbl...
> We're building a new W2K server with the same name as the current one. We
> are taking down the old server, moving all the datafiles to the new
server,
> installing SQL Server, Analysis Services and sp3. The last time we did
this
> we lost our DTS packages. Can I export them somehow and then import them?
> Are they not stored in the system tables?
> Thanks,
> Doug
>|||OK, I saved a package to a .dts file. How do I import/execute that file?
Thanks,
Doug
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:Ormd6IFDEHA.3568@.tk2msftngp13.phx.gbl...
> They are stored in the MSDB database, but moving that database is always
> trickey. You can load the DTS packages into Enterprise Mangler and save
> them to the file system. You can then reload and resave them when the new
> server is ready. If you have a lot of packages, you can write a script
to
> do that automagically using SQL-DMO and the Package2 object.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Doug Stiers" <stiers@.email.com> wrote in message
> news:ehNaTDFDEHA.2308@.tk2msftngp13.phx.gbl...
We
> server,
> this
them?
>|||I found out how to do this by right clicking on the DTS folder in EM
I should have posted my question in: microsoft.public.sqlserver.tools
"Doug Stiers" <stiers@.email.com> wrote in message
news:%231U091FDEHA.3064@.tk2msftngp13.phx.gbl...
> OK, I saved a package to a .dts file. How do I import/execute that file?
> Thanks,
> Doug
>
> "Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
> news:Ormd6IFDEHA.3568@.tk2msftngp13.phx.gbl...
new
> to
> We
> them?
>|||Don't worry about it. .Server is pretty much a catch-all anyway.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Doug Stiers" <stiers@.email.com> wrote in message
news:uIICb9FDEHA.2908@.TK2MSFTNGP09.phx.gbl...
> I found out how to do this by right clicking on the DTS folder in EM
> I should have posted my question in: microsoft.public.sqlserver.tools
>
> "Doug Stiers" <stiers@.email.com> wrote in message
> news:%231U091FDEHA.3064@.tk2msftngp13.phx.gbl...
always
save
> new
script
one.
did
>