How to: Import a Package Using Integration Services Service
You can import packages that are stored in an instance of Microsoft SQL Server, in the file system, or in the SSIS package store. The imported packages are saved to a folder in the SSIS package store.
To import a package
Click Start, point to Microsoft SQL Server 2005, and then click SQL Server Management Studio.
In the Connect to Server dialog box set the following options:
- In the Server type box, select Integration Services.
- In the Server name box, provide a server name or click <Browse for more…> and locate the server to use.
If Object Explorer is not open, on the View menu, click Object Explorer.
In Object Explorer, expand the Stored Packages folder.
Expand the subfolders to locate the folder into which you want to import a package.
Right-click the folder, click Import Package. and then do one of the following:
- To import from an instance of SQL Server, select the SQL Server option, and then specify the server and select the authentication mode. If you select SQL Server Authentication, provide a user name and a password.
Click the browse button (…), select the package to import, and then click OK. - To import from the file system, select the File system option.
Click the browse button (…), select the package to import, and then click Open. - To import from the SSIS Package Store, select the SSIS Package Store option and specify the server.
Click the browse button (…), select the package to import, and then click OK.
- To import from an instance of SQL Server, select the SQL Server option, and then specify the server and select the authentication mode. If you select SQL Server Authentication, provide a user name and a password.
Optionally, update the package name.
To update the protection level of the package, click the browse button (…) and choose a different protection level by using the Package Protection Level dialog box. If the Encrypt sensitive data with password or the Encrypt all data with password option is selected, type and confirm a password.
Click OK to complete the import.
See Also
Tasks
Importing and Exporting Packages
Concepts
Setting the Protection Level of Packages
Package How-to Topics (SSIS)
Other Resources
Creating Packages in SSIS Designer