Share via

Copy Activity error Rows Mismatching

Prapul Kumar Dongari 116 Reputation points
2022-03-16T06:52:12.313+00:00

Hi, Team When I was trying to copy data which contains large XML data columns from sql server to adls using copy activity to CSV format the data in particular column is skipping to new row how can i handle this in adf copy activity.

Azure Data Lake Storage
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,559 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,624 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. AnnuKumari-MSFT 34,556 Reputation points Microsoft Employee Moderator
    2022-03-29T09:19:29.733+00:00

    Hi @Prapul Kumar Dongari ,

    Thankyou for using Microsoft Q&A platform and posting your query. Thankyou for sharing screenshot. It gave me the idea that the data is getting skipped to new row. However, it would have been better if you could share the xml content as well so that it would be easier to reproduce your issue.

    I tried to copy a table having complex xmldata into csv file using copy activity. I didn't face this issue. My suggestion would be to try the following things:

    1. Check if the schema is imported successfully for source and sink or not.
    2. Check if there is any comma present in the data. If yes, try using double quotes in quote character of Sink dataset.

    Please let us know if the suggested response helped you by clicking Accept Answer otherwise please help us with more details to get better understanding. Thanks !

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.