You cannot parameterize only the connection in a mapping. You need to parameterize both the connection and the object for the mapping to run successfully.

Select the field mapping as Parameterized or Automatic. Manual field mapping does not work when you parameterize the source and target connection and objects.

When you parameterize an object and specify an override, the metadata of the overridden object needs to match the specified object in the task properties.

You cannot parameterize the object when you create a new target at runtime.

When you override a parameter using the parameter file, you cannot use input parameters for the source filter, custom query, multiple objects, and the source, lookup, and target advanced source properties.

You can override using the parameter file only if you have defined a parameter in the mapping.