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,076 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
8,453 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Nandan Hegde 27,241 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