Moving Packages
Moving packages is really just deploying a package to a different location. You can handle moving packages in a few ways, and we'll review each of them briefly in this section.
If you right-click any package, you will see menu choices for importing or exporting a package. The package location can be SQL Server, the file system, or the SSIS package store (which is just the special folder in the file system that SSMS scans for packages). Select the new package path (which can even be in the same folder on the same server as long as you give the package a new name), and click OK. There's not much to it!
Alternatively, you can move (and many other operations) from the command line using DTUtil.exe. The syntax isn't the easiest, but ...
Get MCITP Administrator: Microsoft® SQL Server™ 2005 Optimization and Maintenance (70-444): Study Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
