Table of Contents

Search

  1. Preface
  2. Introduction to Microsoft SQL Server Connector
  3. Connections for Microsoft SQL Server
  4. Synchronization tasks with Microsoft SQL Server Connector
  5. Mappings and mapping tasks with Microsoft SQL Server Connector
  6. Replication tasks with Microsoft SQL Server
  7. Data type reference

Microsoft SQL Server Connector

Microsoft SQL Server Connector

Mappings and mapping tasks with Microsoft SQL Server Connector

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.

0 COMMENTS

We’d like to hear from you!