How to dynamically change server url withing http connection manager SSIS?
<p>I am fairly new to SSIS, Visual studio. Thought that might be good to mention in the beginning.</p>

<p>What I wanted to achieve was to download a certain xls file from <a href="http://www.ads-slo.org/statistika/" rel="nofollow">http://www.ads-slo.org/statistika/</a> website and store it in a certain folder on my computer. I have achieved that, but the problem is that I know how to do it one file at a time. I did it by opening new connection, going to http connection and in the manager typing the server url: which in my case if lets say we start with January 2016 was this:<a href="http://www.ads-slo.org/media/xls/2016/Januar-2016.xls" rel="nofollow">http://www.ads-slo.org/media/xls/2016/Januar-2016.xls</a>. After doing so I've constructed a script task or more or less copied it from a website that downloads the file given a certain url based on the connection manager.</p>

<p>My problem is that I would like to download all of the files on this site, so starting with January 2007 and ending with January 2016 with a single package and by not changing my connection manager server url settings 100 times.</p>

<p>Is there any way you might help me. I would be forever grateful.</p>

<p>Thank you in advance.</p>

<p>Kind regards, Domen</p>