December 7, 2016 at 11:33 pm
Comments posted to this topic are about the item Downloading multiple files from internet with SSIS and C#
December 8, 2016 at 6:45 am
Looks like you've given me some studying to do.
December 8, 2016 at 8:42 am
Hahaha. What do you mean? What are you planning to do?
December 8, 2016 at 9:03 am
+1
Super tutorial!
December 9, 2016 at 8:57 am
Really understandable thumbs up to that procedure that collects multiply data.
December 9, 2016 at 2:02 pm
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".
December 17, 2016 at 11:51 am
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.
November 29, 2018 at 10:24 am
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