Load multiple XML files into Azure SQL using Azure Data Factory, with each XML file representing a table in the Azure SQL database. The ADF will copy the XML data and create tables on the fly in Azure SQL. However, I could not make it work. I don’t know what I am missing.
I really appreciate any help you can provide.
following steps setup
- Get MetaData and Filter activities are getting all the xmls.
- For each activity setting @activity(‘Filter’).output.value
-
Copy data activity
source: wildcard file path/@item().name sink: "connection": setting table @dataset().tablename "parameter": tablename "dataset properties":@replace(item().name,'.xml','')