Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

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 (SSIS Tool).

To import or export a package

Integration Services icon (small) 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:

For automatic notification of these updates, subscribe to the RSS feeds available on the page.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.