Importing and Exporting Packages

Packages can be saved either in the sysssispackages table in the SQL Server msdb database or in the file system.

The package store, which is the logical storage that Integration Services service monitors and manages, can include both the msdb database and the file system folders specified in the configuration file for the Integration Services service.

You can import and export packages between the following storage types:

• File system folders anywhere in the file system.

• Folders in the SSIS Package Store. The two default folders are named File System and MSDB.

• The SQL Server msdb database.

Integration Services gives you the ability to import and export packages, and by doing this change the storage format and location of packages. Using the import and export features, you can add packages to the file system, package store, or msdb database, and copy packages from one storage format to another. For example, packages saved in msdb can be copied to the file system and vice versa.

You can also copy a package to a different format using the dtutil command prompt utility. For more information, see dtutil Utility.

To import or export a package

• How to: Import or Export a Package by Using SQL Server Management Studio

Stay Up to Date with Integration Services For the latest downloads, articles, samples, and videos from Microsoft, as well as selected solutions from the community, visit the Integration Services page on MSDN or TechNet: Visit the Integration Services page on MSDN Visit the Integration Services page on TechNet For automatic notification of these updates, subscribe to the RSS feeds available on the page.

See Also

Concepts

Designing Packages in Business Intelligence Development Studio

Managing Packages