Importing SSIS Package Using SQL Server Management Studio
View Imported SSIS Packages in MSDB
All the SSIS packages which you have imported in MSDB using the Import Package can be viewed by connecting to Integration Services using SQL Server Management Studio (SSMS). Once you are connected to Integration Services then expand Stored Packages node and then expand MSDB node, there you will be able to see all the three SSIS packages which you have imported as shown in the snippet below. To import an SSIS Package into MSDB, you need to right click the MSDB node and select Import Package…. from the popup window.
The SSIS packages which are imported in MSDB are stored in SYSSSISPACKAGES table of MSDB system database. When MSDB database is backed up by the database administrator these packages are automatically backed up. You can query the SYSSSISPACKAGES table to see the list of all the SSIS packages which are stored in MSDB database as shown in the below snippet.
In this article you have seen the steps which you need to follow in order to import an SQL Server Integration Services Packages that is stored in another instance of SQL Server, or in File system, or in SSIS Package store using SQL Server Management Studio (SSMS). The same steps you can follow in order to import SSIS packages into an instance of SQL Server 2005.