Exporting SSIS Package Using SQL Server Management Studio
Export Package from File System to another SQL Server Instance using SQL Server Management Studio (SSMS)
1. Connect to SQL Server 2008 Integration Services using SQL Server Management Studio.
2. To export an SSIS Package from File System into another SQL Server Instance, you need to expand the File System node and then right click the SSIS package which needs to be exported and select Export Package…. from the popup window as shown in the snippet below.
3. This will open up Export Package dialog box as shown in the below snippet.
In Export Package screen you need to select Package Location as “SQL Server” from the drop-down list. Next, you need to provide the SQL Server Instance name where you want to export the SSIS package (You won’t be able to export a SSIS package residing on SQL Server 2008 to SQL Server 2005). Then, you need to choose the appropriate authentication mode to connect to the SQL Server Instance. In order to save the SSIS package you need to click “….” button in Package path which will open up SSIS Package window where you need to choose the folder within SQL Server where you want to save the SSIS package. Here you can even provide a new name for the package while specifying the save location for the package within SQL Server. Click OK to close the SSIS Package window. By default, the Protection Level value for the exported package remains as “Encrypt sensitive data with user key”. If you want to change the protection level then you can choose the appropriate one by clicking “….” button and then finally click OK to export package. Once the package is successfully exported it can be viewed by connecting to Integration Services of the destination SQL Server and then expand Stored Packages | File System.