How to build a url with input parameters to download file in SSIS

Question

I'm downloading a file in SSIS. What is the syntax for the URL with input parameters to download a file online with a date range of 10/1/2020 to 10/15/2020. The file name is Oct Download.csv

Answer 1

Hi @MikeY1975 ,

You may use Execute Process Task and Script Task to meet your need.

Here are some helpful links you may take a reference:

how-to-download-a-file-from-internet-using-ssis

download-source-file-from-website-with.html

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.