Downloading multiple files from internet with SSIS and C#

  • Comments posted to this topic are about the item Downloading multiple files from internet with SSIS and C#

  • Looks like you've given me some studying to do.

  • Hahaha. What do you mean? What are you planning to do?

  • +1

    Super tutorial!

  • Really understandable thumbs up to that procedure that collects multiply data.

  • Thank you for the article! I do have a question though. In the last section of the article, it looks like "user::filename" variable is used twice. First time it's used to populate the resultset obtained after running the Execute SQL task (this resultset holds the list of our filenames). Then it's leveraged in the "For Each Loop" as ADO object source variable. So far so good.

    However next, we use it again in the Variable Mapping screen of the "For Each Loop" to populate individual elements (file names) as we loop through the collection. I don't think you can do this, it should be a different variable of type "string".

  • It again boil down to knowing the filename before executing the package. Is there any way where we could just simply go to the website and dynamically parse all the file available for download and download them.

  • I know this is a bit old, but how would you work around a password protected site?  I don't see any way to pass credentials...

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply