Mappings and mapping tasks with Microsoft SQL Server Connector
Use the Data Integration Mapping Designer to create a mapping. When you create a mapping, you configure a source or target to represent a Microsoft SQL Server object.
In advanced mode, the Mapping Designer updates the mapping canvas to include transformations and functions that enable advanced functionality.
Describe the flow of data from source and target along with the required transformations before the agent writes data to the target. When you create a mapping task, select the mapping that you want to use. Use the Mapping Task wizard to create a mapping task. Validate and run the mapping to read data from sources and write to a target. The mapping task processes data based on the data flow logic you define in the mapping.