Saving Packages

In Business Intelligence Development Studio you build packages by using SSIS Designer and save the packages to the file system as XML files (.dtsx files). You can also save copies of the package XML file to the msdb database in SQL Server or to the package store. The package store represents the folders in the file system location that the Integration Services service manages.

If you save a package to the file system, you can later use the Integration Services service to import the package to SQL Server or to the package store. For more information, see Importing and Exporting Packages.

You can also use a command prompt utility, dtutil, to copy a package between the file system and msdb. For more information, see dtutil Utility (SSIS Tool).

To save a package

• How to: Save a Package to the File System

• How to: Save a Copy of a Package

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