Export (0) Print
Expand All
2 out of 5 rated this helpful - Rate this topic

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 2005 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.

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

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.