Troubleshooting Dynamic Mappings

The dynamic ports in my mapping include a column with XML data type, and the mapping failed.

You cannot propagate XML data through a mapping if any of the following conditions are true:

• - You configure the Read or Write transformation to get columns from the data source.
• - You configure the Write transformation to get columns from the data flow.
• - You configure the data obect for the target to create or replace the target at run time.

My dynamic mapping failed with run-time errors for parameters and links. I would like to make sure that the parameters and links successfully resolve before I run the mapping.

When you run a dynamic mapping, the Data Integration Service compiles the mapping to complete the following tasks:

• - Resolve parameter values.
• - Expand dynamic ports and convert generated ports to static ports.
• - Link static ports.
• - Resolve run-time links to connect the ports.

You can view the optimized mapping to see the compiled version of a mapping. Right-click an empty area in the mapping editor and click Show Optimized Mapping. The Data Integration Service generates the optimized mapping. You can review the optimized mapping, fix any issues, and then run the mapping.

The following image shows a dynamic mapping that contains transformations with dynamic ports:

The following image shows the compiled version of the dynamic mapping in which the generated ports are converted to static ports and are linked: