Lesson 6: Use parameters with the Project Deployment Model in SSIS

APPLIES TO: yesSQL Server, including on Linux yesAzure SQL Database yesAzure SQL Data Warehouse noParallel Data Warehouse

SQL Server 2012 introduced a new deployment model where you can deploy your projects to the Integration Services server. The Integration Services server enables you to manage and run packages, and to configure runtime values for packages.

In this lesson, you modify the package that you created in Lesson 5: Add SSIS package configurations for the Package Deployment Model to use the Project Deployment Model. You replace the configuration value with a parameter to specify the sample data location. You can also copy the completed Lesson 5 package that is included with the tutorial.

By using the Integration Services Project Configuration Wizard, you convert the project to the Project Deployment Model. This model uses a parameter rather than a configuration value to set the Directory property. This lesson partially covers the steps you would follow to convert existing SSIS packages to the new Project Deployment Model.

When you run the package again, the Integration Services server uses the parameter to populate the value of the variable. The variable in turn updates the Directory property. The package iterates through the files in the data folder specified by the new parameter.

Note

If you haven't already, see the Lesson 1 prerequisites.

Lesson tasks

This lesson contains the following tasks:

  1. Step 1: Copy the Lesson 5 package

  2. Step 2: Convert the project to the Project Deployment Model

  3. Step 3: Test the Lesson 6 package

  4. Step 4: Deploy the Lesson 6 package

Start the lesson

Step 1: Copy the Lesson 5 package