How to *easily* import multiple DTS packages? 1

[Palooka]

I previously posted this question in MS SQL Server: Programming, but I guess this is actually the right place.

I am currently upgrading a system from SQL Server 2000 to 2005. At this time migrating from DTS to SSIS is not an option.

Thanks to Nigel Rivett and his excellent Save-all-DTS-packages-to-files-script I now have all my 63 DTS packages saved as .DTS-files.

Now I am looking for an easy way to import them into SQL Server 2005. So far I have only been able to import them "manually" one at a time.

Does anyone know of a way to import them all at once, in one batch, or in some kind of automated process? Maybe through a script, or stored procedure?

 

[MDXer]

DTS Backup 2000 is a great tool it will allow you to backup restore or even move packages from one server to another even when encrypted as long as you have the password.
[URL unfurl="true"]http://www.sqldts.com/272.aspx[/url]

Paul
---------------------------------------
Shoot Me! Shoot Me NOW!!!
- Daffy Duck

 

[Palooka]

I look forward to give it a try later today. I'm exited to see if it will work with a 2005 database installation.

Wether or not it works with 2005, I will still keep it for future jobs. This tool looks excellent.

Thanks for a great tip.

--
Kjetil Myhre

http://www.kmyhre.com

http://leilighet.kmyhre.com

 

[MDXer]

There are better ways in 2005 such as doing filesystem deployments.

Paul
---------------------------------------
Shoot Me! Shoot Me NOW!!!
- Daffy Duck