I'm rathernew to SSIS and need some help creating an SSIS package that will connect to an HTTPS URL and download daily files with a naming convention like 2012-04-09.csv, 2012-04-08.csv and so on. Any suggestions on how to do this using a Web Service, XML, FTP or any other task would be much appreciated. Thank you!!
I believe your best bet would be to use a custom script component to create your own.
This link shows you how to do it: http://microsoft-ssis.blogspot.pt/2011/05/download-source-file-from-website-with.html
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With