Microsoft SQL Server Connector Guide > Data Synchronization Tasks with Microsoft SQL Server Connector > Microsoft SQL Server Targets in Data Synchronization Tasks
  

Microsoft SQL Server Targets in Data Synchronization Tasks

You can use a single object as a target in a Data Synchronization task.
The following table describes the Microsoft SQL Server target properties:
Property
Description
Connection
Name of the active target connection.
Target Object
Name of target objects available in the connection.
Truncate Target
When you enable the Truncate Target option, the Secure Agent drops and recreates the table before it writes the data to the target. Default is false.
Enable Target Bulk Load
Uses Microsoft SQL Server bulk API to write data in bulk mode to Microsoft SQL Server.
Display target fields in alphabetical order
Enables data preview in an alphabetical order.