This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(83.2, 45%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMP%3C/text%3E%3C/svg%3E)
How to trigger a pipeline in Azure Synapse based on file getting dropped into a file server? Any workarounds? File Server connected through integration runtime. Thank you for your help!
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
An Azure service for ingesting, preparing, and transforming data at scale.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(192, 26%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EH%3C/text%3E%3C/svg%3E)
Hello @Moore, Payton E ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .In case if you have any resolution please do share that same with the community as it can be helpful to others . Otherwise, will respond back with the more details and we will try to help .
Thanks
Himanshu
Hello @Moore, Payton E ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .In case if you have any resolution please do share that same with the community as it can be helpful to others . Otherwise, will respond back with the more details and we will try to help .
Thanks
Himanshu
Hey ,
Based on my knowledge, unfortunately there is no way to have an event trigger on file server or file share.
Below links explain the same:
Hello @Moore, Payton E ,
Thanks for the ask and using the Microsoft Q&A platform .
Can you please elaborate as what do you mean by the file server ?
Anyways since the Event trigger only supports "Azure Data Lake Storage Gen2 and General-purpose version 2 storage accounts" , you will have to look for some custom solution .
One way can be to use tumbling window trigger and then we add a pipeline with the getmetadata activity and check for any new files arrived in the last X minutes .
Updated on 8/11
We currently have the trigger set to a specific time but would like to do an event-based trigger based on when files land into the specific folder on the file server
@Nandan Hegde rightly called out that the event based trigger is not supported for file server . I have a suggestion which i think you can think about , copy the file from this file share to a BLOB . By doing that you will be able to use event based trigger on that .
Please do let me know how it goes .
Thanks
Himanshu
Please do consider clicking on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members
Thank you for your response @HimanshuSinha . To elaborate, the file server is located on a virtual machine. We used integration runtime to connect to the file server to pick up csv files from a specific folder. We currently have the trigger set to a specific time but would like to do an event-based trigger based on when files land into the specific folder on the file server. These files will come rarely and and random times ie. once every month or every 2 weeks. Any suggestions on how we set this up?