How to fetch the file placed in azure storage container to local machine using SSIS

Question

I want to write a SSIS package to fetch the file placed in my azure storage container to my local machine , can i know any good article which explains it.

Is your blob container public or private (can you list/get object without authentivation)? — Matej, Dec 02 '11 at 08:44

score 3 · Accepted Answer · edited May 23 '17 at 12:27

3

The easiest way do download singe file is to create Script Task and then use WebClient.DownloadFile.

using (var wc = new WebClient())
{
    wc.DownloadFile("url", "localFileName")
}

You can also check How to make an HTTP request from SSIS?

edited May 23 '17 at 12:27

Community

1
1

answered Dec 02 '11 at 12:29

Matej

7,517
2
36
45

How to fetch the file placed in azure storage container to local machine using SSIS

1 Answers1