September 1, 2010 at 2:42 pm
Hi,
We have a vendor that provides us a url from where we can save the spreadsheet to our system. So, its like http://www.getfile.com and the open dialog box appears whether to save the file or open it.
What task should i use to save that file from the web in our local directory using SSIS? I have done something similar to FTP where using FTP task, saved the file in our local directory.
I did see a HTTP connection manager where you can specify your url. But not sure what task to use so as to save the file. Please advise!
Thanks!
September 1, 2010 at 3:30 pm
A PowerShell script might be an option. Not having done this before but looks cool:
http://msdn.microsoft.com/en-us/library/ez801hhe%28VS.80%29.aspx
If you check the "Community Content" at the bottom of the page it has a 2 line PowerShell script (v2.0) that allows you to download a file. I would imagine the link has to be a absolute link, meaning something like "http://www.getfile.com/myfile.xls"
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply