File Download Is HTML Instead of Real Data

Question

File Download Is HTML Instead of Real Data

Stacy Bell 41

I'm using this example to download a file download-source-file-from-website-with.html. I got an error

The request was aborted: Could not create SSL/TLS secure channel.

I made a change in the registry to resolve it. cant-connect-project-online-odata-from-ssis The download has the pages html instead of the file data. Any ideas?

2 answers

Your answer

Answer 1

ZoeHui-MSFT 41,491

Hi @Stacy Bell ,

Are you trying to download a file from website?

If yes, you may try with downloading-a-file-over-http-the-ssis-way to see if it is helpful.

Also take a reference below:

how-do-i-login-to-a-website-and-download-files-in-c
how-to-download-file-and-then-mark-as.html

Regards，

Zoe

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

MikeY1975 41 Reputation points

2021-12-29T04:25:42.143+00:00

I'm downloading a file from a website. I need to log in and pass parameters. I tried using the HTTP Connection Manager option download-source-file-from-website-with.html. I also tried editing the WebClient option from the same article and changed the DownloadURL to https://www.test.com/login?.login="myusername"&passwd="mypassword"/?#/Reports?start%20date=10/1/2021&end%20date=10/15/2021
but the download file only has the website's html code instead of data.
MikeY1975 41 Reputation points

2021-12-29T04:49:41.653+00:00

I also tried downloading-a-file-over-http-the-ssis-way with the same results.

Answer 2

Olaf Helper 47,436

Could not create SSL/TLS secure channel.

You try to download a file over a secured Https connection. SSIS standard tasks don't support that and all your examples are using unsecured Http connection, therefore non of them works for you.
See instead How to download a file from http and https in C# ; you can use it in a SSIS Script task, as in one of the examples.

Stacy Bell 41 Reputation points

2021-12-29T14:21:24.33+00:00

I couldn't get any of them to work.
Olaf Helper 47,436 Reputation points

2021-12-30T07:01:11.603+00:00

I can't do anything with the phrase "doesn't work", we need a few more details.
Which solution did you try / which code do you use?
Stacy Bell 41 Reputation points

2021-12-30T15:02:55.15+00:00

On the first try I added the following.
wc.Credentials = new NetworkCredential("username", "password");
System.Net.ServicePointManager.SecurityProtocol = System.Net.SecurityProtocolType.Tls | System.Net.SecurityProtocolType.Tls11 | System.Net.SecurityProtocolType.Tls12;
The file download didn't have data. It had the site's html code.

On the second try I added the following.
wc.Credentials = new NetworkCredential("username", "password");
The file download didn't have data. It had the site's html code.

On the third try I added the following.
wc.Credentials = new NetworkCredential("username", "password");
It didn't download the file and left the console window open.

Share via

File Download Is HTML Instead of Real Data

2 answers

Your answer