Azure Blob Storage as Source and FTP as destination

0
votes

Is there anyway I can transfer txt files from my Azure Blob Storage to a FTP directly, going serverless? If possible using SSIS or Azure Data Factory.

Thanks!

3
azuressisftpazure-data-factoryazure-blob-storage
you can also use logic app, it has blob and ftp connectors – Thomas
I tried it, I couldn't find the blob storage "blob content" to put on the FTP destination, searched for examples/documentation and didn't find anything that could help me. – Turque
would you like some samples ? – Thomas
That would be great @Thomas – Turque
have you seen my answer ? – Thomas

3 Answers

2
votes

you can use Azure Logic App:

A simple logic app to push a blob to a FTP would be:

Azure LogicApp - Blob to FTP

1
votes

SSIS has a lot of connectors that can talk directly to AZURE storage. As for FTP, you may have to use a third party software (WinSCP) that can accomplish uploading of the file to FTP (if the built in FTP Task doesnt accomplish it already). If you are looking to go directly from Azure to FTP, you may have to rely on custom C# code. I am not even sure if that is possible.

0
votes

You could use SSIS. Azure data factory copy activity doesn’t support ftp as sink.