Our requirement is to copy data from Azure Sql database to Microsoft Sql server (On Azure VM).
Example:
If from source there are 50 rows which contains 5 error rows.
Question 1:
How to skip the 5 error rows and copy the 45 rows to sink ?
We tried this fault tolerance setting( Please refer the attachment)
but copy activity failed with just Foreign key error and the log file just contains only the header as shown below
Timestamp,Level,OperationName,OperationItem,Message
Question 2:
Will the error row handling option be available in dataflow for sql server sink anytime soon?