Microsoft SQL Server Connector Guide > Mappings and Mapping Configuration Tasks with Microsoft SQL Server Connector > Microsoft SQL Server Targets in Mapping
  

Microsoft SQL Server Targets in Mapping

To write data to a Microsoft SQL Server database, configure a Microsoft SQL Server object as the Target transformation in a mapping. You can use the full pushdown optimization to write data to Microsoft SQL Server.
Specify the name and description of the Microsoft SQL Server target. Configure the target and advanced properties for the target object.
The following table describes the target properties that you can configure for a Microsoft SQL Server target:
Property
Description
Connection
Name of the active Microsoft SQL Server target connection.
Target Type
Type of the Microsoft SQL Server target object available. You can choose from the following source types:
  • - Single
  • - Parameter
Target Object
Name of the Microsoft SQL Server target object based on target type selected.
Specify the target object that you want to create at run time. You can also select an existing object from the list.
Operation
Select the target operation. You can perform the following operations on a Microsoft SQL Server target:
  • - Insert
  • - Update
  • - Upsert
  • - Delete
  • - Data Driven
Truncate target
When you enable the Truncate Target option, the Secure Agent truncates the table before running the task. Default is not selected.
Enable Target Bulk Load
Uses Microsoft SQL Server bulk API to insert data in bulk mode.
When you create a Mapping Configuration task, you can use the Microsoft SQL Server bulk API to perform insert operation.
If you select the Forward Rejected Rows option, the Secure Agent flags the rows for reject and writes them to the reject file. If you do not select the Forward Rejected Rows option, the Secure Agent drops rejected rows and writes them to the session log file. The Secure Agent does not write the rejected rows to the reject file.