Package Installation Wizard

Another wizard that you may see and use regularly is the Package Installation Wizard, which walks you through installing your SSIS project onto a new server. You may receive a .SSISDeploymentManifest file from a vendor or from a developer to run. If you double-click on the file ProSSISChapter5 .SSISDeploymentManifest, for example, it would launch the Package Installation Wizard to install the SSIS project called ProSSISChapter5 into a new environment.

After the wizard's introduction screen, you must choose whether you'd like the wizard to install the packages onto the SQL Server (msdb database) or install them as files on the server. If you select files, you will be prompted for the location you'd like them placed. If you select SQL Server, you'll be prompted for the SQL Server onto which you'd like to install the package.

This wizard will be covered in greater detail in Chapter 18 when deployments are discussed. Until then, you can create a manifest file yourself by right-clicking on a project and selecting Yes for the CreateDeploymentUtility option in the Deployment Utility page.