Lesson 1: Preparing to Create the Deployment Bundle

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

Lesson Tasks

This lesson contains the following tasks:

• Step 1: Creating Working Folders and Environment Variables

• Step 2: Creating the Deployment Project

• Step 3: Adding Packages and Other Files

• Step 4: Adding Package Configurations

• Step 5: Testing the Updated Packages

Start the Lesson

Step 1: Creating Working Folders and Environment Variables

Stay Up to Date with Integration Services For the latest downloads, articles, samples, and videos from Microsoft, as well as selected solutions from the community, visit the Integration Services page on MSDN or TechNet: Visit the Integration Services page on MSDN Visit the Integration Services page on TechNet For automatic notification of these updates, subscribe to the RSS feeds available on the page.