Chapter 10 Quick Reference

Open table as spreadsheet

To	Do this
Configure a project to create a deployment utility	Right-click the project name in Solution Explorer and choose Properties. In the Property Pages dialog box, set the CreateDeploymentUtility, AllowConfigurationChanges, and DeploymentOutputPath properties.
Create a Configure Deployment Utility manifest file	After configuring the project, right-click the project name in Solution Explorer and choose Build.
Run the Package Installation Wizard	In Windows Explorer, double-click the <project name>.SSISDeployment-Manifest file located in the project's Bin\Deployment folder.
Encrypt package contents	Set ProtectionLevel and, optionally, PackagePassword for a package in the Properties window.
Password protect a package	Set PackagePassword for a package in the Properties window.
Apply role-based security to a package deployed to SQL Server	Use SQL Server Management Studio (SSMS) and connect to Integration Services. Expand Stored Packages, the MSDB database, and the deployed package name. Right-click the package and choose Package Roles from the menu. Use the Package Roles dialog box to apply the default or specific database roles for the MSDB database.
Run a package from SSMS	Right-click the deployed package name under the File System or MSDB folder located under Stored Packages. Choose Run Package from the menu. Use Execute Package Utility to modify options and execute the package.
Run a package from the command line	Run DTExec with the package name and options copied from the Execute Package Utility command-line page.