Ssis msdb vs file system

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 dtutil. For more information, see dtutil Utility. However, there are some restrictions on importing and exporting a package between different versions of SQL Server:. On an instance of SQL Server 9. Click the browse button To update the protection level of the package, click the browse button If the Encrypt sensitive data with password or the Encrypt all data with password option is selected, type and confirm a password.

Optionally, update the default name of the package, and then click OK. Optionally, enter a new name for the package in the Package Name text box. Click OK. Package location Select the type of storage location to import the package to.

The following options are available:. This option is available only if the storage location is SQL Server. Package path Type the package path, or click the browse button Package name Optionally, rename the package. The default name is the name of the package to import. Protection level Click the browse button Use the Export Package dialog box, available in SQL Server Management Studio, to export a Integration Services package to a different location and optionally, modify the protection level of the package.

Package location Select the type of storage to export the package to. Packages saved to msdb can be backed up and restored using SQL Server backup and restore features. For more information about backing up and restoring the msdb database, click one of the following topics:. Add a comment. Active Oldest Votes. SQL Server If memory serves correct - stored in msdb. Wrapup Ultimately, where you store your packages does not affect your ability to run them.

References Package Management. Improve this answer. Thank Bill. Any idea what the differences here are?

They seem about the same to me. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. Sign in. United States English. Ask a question. Quick access. Search related threads. Remove From My Forums. Answered by:.