| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic |
|---|---|---|---|---|---|---|---|
Lesson 6: Use parameters with the Project Deployment Model |
Lesson 6: Use parameters with the Project Deployment Model in SSIS |
chugugrace |
chugu |
01/11/2019 |
sql |
integration-services |
tutorial |
[!INCLUDEsqlserver-ssis]
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 [!INCLUDEssISnoversion] 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.
This lesson contains the following tasks: