MS SQL Server Table

Parameter
Value
connectionString
the encrypted connection string. See ".NET Framework Data Provider for SQL Server" section on https://www.connectionstrings.com/sql-server/ for a sample.
table
the name of the domain and table e.g. dbo.employees_new
idColumn
the name of the identity column that exists in the target (or a single column that is guaranteed to be unique and automatically populated for every new record)
idColumnDataType
the data type of the id column

Before 4.0

  • connectionString: the encrypted connection string. See ".NET Framework Data Provider for SQL Server" section on https://www.connectionstrings.com/sql-server/ for a sample.
  • schema: the schema of the table, e.g. dbo
  • table: the name of the domain and table e.g. dbo.employees_new
  • idColumn: the name of the identity column that exists in the target (or a single column that is guaranteed to be unique and automatically populated for every new record)
  • idDataType: the data type of the id column
<SqlServerTableTarget
connectionString="DDE1MhWuA0xYbwFvSnu1fEZ2uD2GpsMRdw9DMV/kmMAfLUdkhkdzrD0Ikk/9dd114wRu9VKrVPSztrcIcSyz2UEFRRANfocc8KJEQXfKDuU="
schema="dbo"
table="employees_new"
idColumn="id_col"
idDataType="Number">
<ColumnMappings>
<ColumnMapping sourceColumn="employee_id" targetColumn="employee_id_new" />
<ColumnMapping sourceColumn="name" targetColumn="name_new" />
</ColumnMappings>
<SyncKey>
<SyncKeyColumnReference name="employee_id_new" />
</SyncKey>
<NewRecordBehaviour type="INSERT" />
<DroppedRecordBehaviour type="EXPIRE" expirationTimestampField="expiry_date_new" />
</SqlServerTableTarget>

CLI 4.0+

  • connectionString: the encrypted connection string. See ".NET Framework Data Provider for SQL Server" section on https://www.connectionstrings.com/sql-server/ for a sample.
  • table: the name of the table including the schema, e.g. dbo.employees
  • idColumn: the name of the identity column that exists in the target (or a single column that is guaranteed to be unique and automatically populated for every new record)
  • idDataType: the data type of the id column
<SqlServerTableTarget
connectionString="DDE1MhWuA0xYbwFvSnu1fEZ2uD2GpsMRdw9DMV/kmMAfLUdkhkdzrD0Ikk/9dd114wRu9VKrVPSztrcIcSyz2UEFRRANfocc8KJEQXfKDuU="
table="dbo.employees_new"
idColumn="id_col"
idDataType="Number">
<ColumnMappings>
<ColumnMapping sourceColumn="employee_id" targetColumn="employee_id_new" />
<ColumnMapping sourceColumn="name" targetColumn="name_new" />
</ColumnMappings>
<SyncKey>
<SyncKeyColumnReference name="employee_id_new" />
</SyncKey>
<NewRecordBehaviour type="INSERT" />
<DroppedRecordBehaviour type="EXPIRE" expirationTimestampField="expiry_date_new" />
</SqlServerTableTarget>