copy xml files from SFTP to Azure blob

Anonymous
2023-11-17T07:59:45.8966667+00:00

Hello,

I want to bring xml files from SFTP which is just created yesterday to the Azure blob storage and then doing transformation. the xml files have a complex structure and they don´t follow XSD or DTD.

I found in the copy there is xml file option for source file but I can not find xml file option for sink.

is there any solution to do this?

Azure Blob Storage
Azure Blob Storage
An Azure service that stores unstructured data in the cloud as blobs.
2,776 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,521 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Nandan Hegde 31,946 Reputation points MVP
    2023-11-17T09:03:28.6433333+00:00

    Hey,

    You can use binary dataset type to copy files as is from source to sink (any file type would be copied)

    As for your query, XML type is not supported as SInk in ADF :

    User's image

    https://learn.microsoft.com/en-us/azure/data-factory/format-xml

    0 comments No comments

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.