Fetching files stored in azure container using SSI

问题:

Can any one suggest simple example to fetch the file from my windows azure container and place the file on local machine using SSIS - execute process task

回答1:

Based on this article, it seems that standard FTP is an option for you. To simplify your life, I'd create an ftp file that performs the download operations and then call that from your Execute Process Task via ftp.

Content of the batch would be approximately

Executable C:\Windows\System32\ftp.exe Arguments -s:"C:\myFTPcommands.txt' somewhere.azure.com

Contents of C:\myFTPcommands.txt would be

myusername
myPassword
bin
get myBlob.blob

You can test it by opening a command prompt (Win-R cmd) and then calling ftp -s:"C:\myFTPcommands.txt' somewhere.azure.com Once that's working successfully, try it from SSIS.

Reference example of command line ftp