Status:
Completed
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.
5 Comments
CopyJob already supports TIMESTAMP and INTEGER datatypes for incremental column. What is your data source and exact data type ?
- Status added:New
- Status changed:NewtoPlanned
- Status changed:PlannedtoCompleted
- 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.
