Copy Job needs to support TIMESTAMP (ROWVERSION) data type for Incremental Column

Please get the Copy Job to support TIMESTAMP (or ROWVERSION) column data types as the Incremental column for the wizard.

This data type is the absolute BEST type for this use case. All others can be hacked or missed by users, systems, or errors.

Same was true for the Meta Data Driven Copy Wizard in ADF but we managed to hack the pipeline tasks to make it happen. Not so here.

ajarora
Microsoft Employee
1 year ago
CopyJob already supports TIMESTAMP and INTEGER datatypes for incremental column. What is your data source and exact data type ?
fbcideas_migusr
New Member
1 year ago
Status added:
New
yexu
Microsoft Employee
6 months ago
Status changed:
New
to
Planned
yexu
Microsoft Employee
5 months ago
Status changed:
Planned
to
Completed
JDownes
New Member
5 months ago
Incompatible data type mapping from column DeliveryTime to column DeliveryTime Source Type: time Column: DeliveryTime Destination: Type: timestamp I have a few tables I am unable to use copyjob simply due to this error.