Migration SSIS in msdb to other server

I depolyed several package in a server A msdb in some logical folders

E.g. msdb\Task1\package1

msdb\Task2\package2

msdb\Task3\package3

I would like to migrate the package to other server B and keep the logical folders tree.

I know I can reploy the packages in B and move them to the logical folders tree one by one, it is too slow.

Is there any fast method to migrate the package and keeping the tree?

Thanks.

Sure, move the tables directly. Should work.

You can use a package to move rows in the sysdtspackagefolders90 and sysdtspackages90 tables. Move the packagefolders rows first to retain RI.

Be careful that there aren't identically named folders or packages, it could get confusing. Also, do this too much and you'll get duplicate IDs etc. So, proceed with caution!!!

Kirk Haselden
Author "SQL Server Integration Services"