question

BrianCiampa-0215 avatar image
0 Votes"
BrianCiampa-0215 asked KranthiPakala-MSFT commented

Azure Data Factory Move On-Prem File to Another On-Prem Directory

I would like to do this and am wondering if it is possible in Azure Data Factory:

  1. Connect to an on-premesis ftp server

  2. Copy data from an on-premesis .csv file

  3. Move the .csv file into a new folder on the on-premesis ftp server

Is that possible? If ADF cannot do that natively, can ADF execute a local .bat file?

azure-data-factory
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

KranthiPakala-MSFT avatar image
0 Votes"
KranthiPakala-MSFT answered KranthiPakala-MSFT commented

Hi @brianciampa-0215,

Welcome to Microsoft Q&A forum and thanks for reaching out here.

Unfortunately ADF FTP connector doesn't support writing to sink/FTP, it only supports source/Reading from FTP. Hence the is answer is No

142598-image.png

Ref doc: ADF Connectors overview

As their is no native support to write to FTP using ADF, to move data to/from a data store that the service does not support, or to transform/process data in a way that isn't supported by the service, you can create a Custom activity with your own data movement or transformation logic and use the activity in a pipeline. The custom activity runs your customized code logic on an Azure Batch pool of virtual machines. You may also try exploring Azure function activity

If you have any feedback or a feature request, we suggest you to please submit your feedback or suggestion in ADF feedback forum here : https://feedback.azure.com/d365community/forum/1219ec2d-6c26-ec11-b6e6-000d3a4f032c

All the feedback shared in this forum are actively monitored and reviewed by ADF product team. Also please do share the feature request feedback link here once it is created so that others with similar idea can upvote and comment on it.

Hope this info helps. Do let us know if you have further query.



  • Please don't forget to click on 130616-image.png and upvote 130671-image.png button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how

  • Want a reminder to come back and check responses? Here is how to subscribe to a notification

  • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators


image.png (25.0 KiB)
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @brianciampa-0215,

Just checking in to see if the above suggestion was helpful. If it answers your query, please do click “Accept Answer” and/or Up-Vote, as it might be beneficial to other community members reading this thread. And, if you have any further query do let us know.

0 Votes 0 ·

Hi @brianciampa-0215,

We still have not heard back from you. Just wanted to check if the above information was helpful? If it answers your query, please do click “Accept Answer” and/or Up-Vote, as it might be beneficial to other community members reading this thread. And, if you have any further query do let us know.

0 Votes 0 ·