Microsoft Azure Synapse SQL Connector

Back Next

Parameterization

You can parameterize the connection, objects, and the advanced runtime properties in mappings.

Consider the following rules and guidelines when you use parameterization:

General guidelines: When you create a mapping with a parameterized target that you want to create at runtime, set the target field mapping to automatic.
You cannot parameterize the field mapping.
Mappings: When you use input parameters, specify the parameter name in the following format:
When you use input parameters, specify the parameter name in the following format:
Format in a mapping task: $name$
Format in a parameter file: $name

When you use in-out parameters, specify the parameter name in the following format in a mapping task or a parameter file: $$name.