Lesson 1: Preparing to Create the Deployment Bundle
Applies To: SQL Server 2016 Preview
In this lesson, you will create the working folders and environment variables that support the tutorial, create an Integration Services project, add several packages and their supporting files to the project, and implement configurations in packages.
Integration Services deploys packages on a project basis; therefore, as the first step in creating the deployment bundle, you must collect all the packages and package dependencies into one Integration Services project. Frequently it is useful to include other information with the deployed packages: for example you will also add to the project a Readme file that provides basic documentation for this group of packages.
After you have added the packages and files, you will add configurations to packages that do not already use configurations. The configurations update properties of packages and package objects at run time. In a later lesson, you will modify the values of these configurations during package deployment to support the packages in the deployed-to environment.
After you have added the configurations, you should open the packages in SSIS Designer, the Integration Services graphical tool for building ETL packages, and examine the properties of packages and package elements as well as the package configurations to better understand the issues that the deployment needs to address. For example, one of the packages extracts data from text files, so the location of the data files must be updated before the deployed packages will run successfully.
Estimated time to complete this lesson: 1 hour