Hello,
I have a requirement where in the user will upload delimited file in the Azure Blob Storage and the Azure Data Factory pipeline will copy the file from Azure Blob Storage
and dump it into Azure SQL DB.
To achieve this, I have created a Container by the name-Import and in that I have created folder by the name Incoming.
so, when the user uploads the file, the file will be added in Import/Incoming location of the Blob Storage.
The user will upload files of any file name like import.csv or Import_10072020.csv etc.
I have configured an Event based trigger which will trigger when the blob is created.
No my difficulty is that how to set the wild card file name in the Event Trigger and Azure Blob Storage Dataset and Copy Data sSource
If I hard code the file name then everything works fine, but as the file names will not be constants, how to set the wild card file name in Event Trigger, Dataset and in
Copy Data source? (Screen shots attached for reference)








