copy xml files from SFTP to Azure blob

reza 20 Reputation points
2023-11-17T08:18:43.01+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 Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
0 comments No comments
{count} votes

Answer accepted by question author
  1. Nandan Hegde 36,716 Reputation points MVP Volunteer Moderator
    2023-11-17T09:04:14.6733333+00:00

    Duplicate query :

    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

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful

Your answer

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