Downloading multiple files from internet with SSIS and C#

  • Daniel Calbimonte

    SSCarpal Tunnel

    Points: 4757

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

  • akljfhnlaflkj

    SSC Guru

    Points: 76202

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

  • Daniel Calbimonte

    SSCarpal Tunnel

    Points: 4757

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

  • gbritton1


    Points: 6520


    Super tutorial!

  • Molelekitebogo11

    SSC Rookie

    Points: 31

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

  • Misha_SQL


    Points: 5395

    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".

  • Shadab Shah

    SSCarpal Tunnel

    Points: 4759

    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.

  • Prometheus112


    Points: 423

    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 8 (of 8 total)

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