D365 ADF sink connector

Mandya Krishna, Vikyath 1 Reputation point
2022-08-22T14:34:03.48+00:00

Do we have option to redirect error rows or continue with processing next rows in ADF mapping data flow for D365 sink connector.

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,688 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. ShaikMaheer-MSFT 38,126 Reputation points Microsoft Employee
    2022-08-23T09:34:14.197+00:00

    Hi @Mandya Krishna, Vikyath ,

    Thank you for posting query in Microsoft Q&A Platform.

    You need to consider using Assert Transformation or Conditional Split Transformation to filter error rows from source and then accordingly load then to sink.

    Please check below two videos that help you to understand this better.
    Assert Transformation in Mapping Data Flows in Azure Data Factory
    Handle Error Rows in Data Factory Mapping Data Flows

    Hope this helps.

    ------------

    Please consider hitting Accept Answer button. Accepted answers help community as well.