I want to download some files from Website URL using SSIS package or c# code But the problem is that website is buildup using flash and i need to login first then only I can go to homapage from w.

• What Is Ssis
• What Is Ssis Package

I'm interested in knowing how I can make an HTTP call from SSIS. For example, I would like to be able to download a file from http://www.domain.com/resource.zip and record the datetime of the download and the destination of the file on the drive. I would also like to capture such attributes as file size and capture the date & time when the download completed.

3 Answers

You can make use of the namespace System.Net.WebClient to make the Http request with the help of Script Task in SSIS. Following example shows how this can be achieved. The example was created in SSIS 2008 R2.

How to uninstall homeguard. Step-by-step process:

1. Create a new SSIS package and create two variables namely RemoteUri and LocalFolder. Set the variable RemoteUri with the value http://www.google.com/intl/en_com/images/srpr/logo1w.png. this is the image url of the logo on the Google's home page. Set the variable LocalFolder with the value C:temp. this is the path where we are going to save the content. Refer screenshot #1.

2. On the SSIS package, place a Script Task. Replace the Main() method within the script task with the code provided under the Script Task Code section. Refer screenshot #2.

3. Screenshot #3 shows that the path C:temp is empty.

4. Screenshot #4 shows successful execution of the package.

5. Screenshot #5 shows that the content (in this case the logo image) has been downloaded to the local folder path.

6. Screenshot #6 shows that the code was tested to download a .zip file. To achieve this, the value of the variable RemoteUri was changed with the content url that needs to be downloaded.

What Is Ssis

Script task code:

C# code that can be used only in SSIS 2008 and above.

Screenshot #1:

Screenshot #2:

Screenshot #3:

Screenshot #4:

Screenshot #5:

Screenshot #6:

Just an alternative for @user756519 script, not as fast, but more bulletproof

This way, webClient doesn't stay hanging, and also you're not dependent on the previous existence of C:Temp directory.Other than that, great answer from @user756519, very detailed.

What Is Ssis Package

Here are a couple of options:

1. Third party tools such as CozyRoc or BlueSSIS.
2. Script Task with WebClient
3. Script Task with HTTP Connection Manager

Script Task Examples at:http://microsoft-ssis.blogspot.com/2011/05/download-source-file-from-website-with.html

Not the answer you're looking for? Browse other questions tagged httpssis or ask your own question.