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(115.19999999999999, 41%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
Hi, inside a Data Factory I need to produce a text file and then put it on a folder of an Azure vm. Any suggests to me in order to solve a such issue? Thanks
![](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(268.8, 8%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EST%3C/text%3E%3C/svg%3E)
Hi @pmscorca ,
Thank you for using Microsoft Q&A platform and thanks for your question.
As I understand you want to know how to use Azure Data Factory (ADF) to generate a text file and place it on a specific folder within an Azure VM. However, due to security restrictions, directly accessing VMs from ADF isn't possible. However, there is a workaround you can consider.
To write a text file to an Azure VM from Azure Data Factory, you can use the "Copy Data" activity in ADF. Here are the high-level steps to achieve this:
I hope this will help. Please let us know if any further queries.
Hi, I'm trying to explain and understand better the question. I think that I could have two possible scenarios. The source is always a Synapse SQL pool. Following the first scenario, inside the Azure vm I could have a shared folder where putting the text file to write. If this shared folder was a "public" one, inside ADF it could enough creating a file system linked service and using an Azure IR, isn't it? In the second scenario, inside the Azure vm I could have a private shared folder where putting the text file to write. So inside ADF I should create a file system linked service plus a self-hosted IR, isn't it? It's a bit curious creating a self-hosted ir to access to a cloud resource (the Azure vm seems a on-premise resource). I'd like to understand better what "Azure VM activity" means; inside ADF it doesn't exist a such activity.
@pmscorca Thank you for providing more details about your scenario. Based on your description, it sounds like you have two possible scenarios for writing a text file from Synapse SQL pool to an Azure VM:
For the first scenario, you can create a file system linked service in ADF that points to the shared folder on the Azure VM. You can then use an Azure Integration Runtime (IR) to copy the text file from Synapse SQL pool to the shared folder on the Azure VM. Since the shared folder is publicly accessible, you do not need to create a self-hosted IR.
For the second scenario, you can create a file system linked service in ADF that points to the private shared folder on the Azure VM. However, since the shared folder requires authentication to access, you will need to create a self-hosted IR on the Azure VM. The self-hosted IR will allow ADF to communicate with the Azure VM and copy the text file to the private shared folder.
I understand your confusion about the Azure VM activity. The "Azure VM activity" mentioned in the previous response referred to the existing activity within ADF that allows you to execute scripts or commands on Azure VMs. It's not a separate activity specifically for file transfer, but rather a tool for interacting with the VM itself.
I hope this helps! Let me know if you have any other questions.
@pmscorca 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 with more details and we will try to help.
Hi @Smaran Thoomu about the "Azure VM activity" do you refer to the script activity?
@pmscorca Yes, it is about the same Script activity. It can be used to achieve this by running scripts or commands on the relevant Azure VM. These scripts could then handle tasks like accessing and manipulating files in the VM's shared folders.
Hi, with the Script activity could I run a file .bat on the vm? It seems that I specify only a SQL script.
Transform data by using the Script activity in Azure Data Factory or Synapse Analytics
Hi @pmscorca
Yes, you can run a .bat file on the Azure VM using the Script activity in Azure Data Factory. The Script activity supports running scripts in multiple languages, including PowerShell, Python, and Batch. To run a .bat file, you can specify the path to the .bat file in the "Script Path" property of the Script activity. Here's an example of how to run a .bat file using the Script activity:
When you run the pipeline, the Script activity will execute the .bat file on the Azure VM.
I hope this helps! Let me know if you have any other questions.
Hi, are you sure about the "Script activity"? I don't see any "Script Path" property and I can select only linked services referred to a database. This activity seems calls only a SQL script. Which is the right ADF activity to run a .bat file on an Azure VM?
@pmscorca I apologize for the mistake I made in my previous responses regarding the Script activity. While it's true that the Script activity can execute scripts in various languages, including Batch, it doesn't directly support running .bat files on an Azure VM.
Hi, but which does ADF activity support the running of a .bat file on an Azure VM?
@pmscorca I apologize for the confusion in my previous responses. The correct answer is that there is no specific activity in Azure Data Factory that supports running a .bat file on an Azure VM. However, you can use the "Web" activity or the "Custom" activity to achieve the desired outcome, depending on your specific security requirements and infrastructure setup.
Thanks for posting your question in the Microsoft Q&A forum.
Did you try Copy Data?
May these articles help you:
https://learn.microsoft.com/en-us/azure/data-factory/connector-file-system?tabs=data-factory
** Please don't forget to close up the thread here by upvoting and accept it as an answer if it is helpful **
Hi, I'm referring to write to an Azure virtual machine (on cloud) and not a local file system or a blob storage.