Export Destination

Export and import of packages can be done from the SSIS storage either through the Windows File System or the Object Explorer in SQL Server Management Studio (SSMS). Packages are exported for various purposes like for package backup, package movement to a different SQL Server and package inclusion in a certain project or solution by using SQL Server Business Intelligence Development Studio (BIDS). Export of packages can be to the MSDB database of SQL Server, the file system or package store of SSIS. Any local or another SQL server or even a file share on another server can be the destination. The extension of the file thus saved is .dtsx.

Steps for Export

For export of a package, say a BioDataImport package to a backup file from SSIS involve the following steps:

1. Open SSMS.
2. Select Integration Services from the Server Type drop-down.
3. Click Connect.
4. Expand the Stored Packages folder.
5. Expand the MSDB folder.
6. Right-click on the package to export.
7. Select Export Package.
8. Select the package destination.
9. Enter the package path and filename. The path must exist already for saving the package.
10. Alternatively, the button next to the Package path field can be clicked for browsing a location.
11. Click OK for saving the package.

The package is saved in XML format by the above steps and may then be imported into another SSMS server or into a BIDS project.

Package Import Steps

Following are the steps for package import in SSMS:

1. Open SSMS.
2. Select Integration Services from the Server Type drop-down.
3. Click Connect.
4. Expand the Stored Packages folder.
5. Right-click on the File System folder.
6. Select Import Package.
7. Select package source.
8. Enter the package path and filename. Alternatively, click on the button next to the Package path field for browsing a package. Click in the Package Name field. The package name is filled in automatically but can be changed if needed.
9. Click OK to save the package.