When you execute a project, all component properties are initialized with the values stored in the repository. Parameter sets provide a way to overwrite some of these values. For example, you can use parameter sets to change database connection settings when you move projects or jobs from development to production. To use parameter sets, you:
Select the component properties you want to use as parameters.
Store sets of parameter values.
Assign a stored parameter set on execution.
Selecting component properties as execution parameters
In the Properties window, right-click all component properties you want to use as execution parameters, and select External.
Right-click all component properties you want to assign a dynamic value using SBN expressions via a parameter set, and select Evaluate. Include all nonprinting values, such as, Tab, CRLF, and so on.
Save the project.
Provide unique names for at least all components that provide project parameters. You may also want to change the prompt and description of the properties. See “Custom properties” for information on how to modify the prompt and description of properties.