Microsoft SQL Server Connector > Synchronization tasks with Microsoft SQL Server Connector > Microsoft SQL Server targets in synchronization tasks
  

Microsoft SQL Server targets in synchronization tasks

You can use a single object as a target in a 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. Select an existing object from the list or create a new object at the run time.
Truncate Target
When you enable the Truncate Target option, the Secure Agent truncates table before writing data to 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
Displays source fields in alphabetical order. By default, fields appear in the order returned by the source system.