ninying90
ninying90

Reputation: 47

Download File from HTTPS to computer using SSIS

Please I am trying to download a File from an HTTPS website.
i have created an HTTP Manager to connect to the website with my password and Username. Now what do i do next to be able to the file with a certain format and dump in a specific folder on my computer?

Upvotes: 0

Views: 2393

Answers (2)

Nick Noodle
Nick Noodle

Reputation: 11

How about something like:

Dim wc As WebClient = New WebClient()
wc.Credentials = New System.Net.NetworkCredential("user-id", "password", "domain")
wc.DownloadFile("https://www.portal.zzz.com/sites/Document area/fff.xlsx", "C:\fff.xlsx")

Upvotes: 0

Riadhovic
Riadhovic

Reputation: 236

Here what you are looking for http://www.sqlis.com/post/Downloading-a-file-over-HTTP-the-SSIS-way.aspx

Upvotes: 1

Related Questions