Specify Target SQL Server (Package Installation Wizard)
Use the Specify Target SQL Server page to specify options for deploying the package to an instance of Microsoft SQL Server 2005.
Options
- Server name
Specify the name of the server to deploy the packages to.
- Use Windows Authentication
Specify whether to use Windows Authentication to log on to the server. Windows Authentication is recommended for better security.
- Use SQL Server Authentication
Specify whether the package should use SQL Server Authentication to log on to the server. If you use SQL Server Authentication, you must provide a user name and password.
- User name
Specify a user name.
- Password
Specify a password.
- Rely on server storage for encryption
Select to use security features of the Database Engine to secure the packages.
- Next
Go to the next page in the wizard.
- Finish
Skip to the Finish the Package Installation Wizard page. Use this option if you have backtracked through the wizard pages to revise your choices and have specified all of the required options.
See Also
Other Resources
Deploying Integration Services Packages
Importing and Exporting Packages
Saving Packages