May 28, 2013 at 2:39 pm
I know this type of question has been asked many times but I can't seem to find a thread that fits my particular situation (or admitedly, perhaps I'm just tired of looking). So here's my deal, I have a URL that I get from a partner by calling another URL and feeding it some query parameters. That call returns to me a URL which is what I need to then go get the file I'm downloading. I have no problem getting that URL into a variable in my SSIS package. It ends up in a format like this:
http://www.company.com/server/GetReport?%5Bsome KVPs]
Needless to say, there are several key-value pairs after that question mark which denote the login information, the report ID that it's picking up, etc.
If I manually take that URL and dump it into IE and hit enter, I get the standard "Open/Save/Cancel" prompt. If I open it, I see the XML that should be in my file in the browser. If I save it, I get the standard save dialoge box so that I can save the xml file.
How do I do this in SSIS? I can create a file connection for where I want this XML file to be saved, but I don't see an option in the XML task to simply save the file from a URL. I'm not sure what the best way to do this is.
Any direction would be much appreciated.
May 13, 2015 at 2:54 pm
I'm having a similar need, did you find a solution to your issue? If so, please post it here.
thanks,
Vic.
May 13, 2015 at 3:58 pm
No, I'm afraid I never solved that issue. We actually found out that the partner in question was releasing a new version of their software which included the ability to interface with their system using a web service so we scrapped the query string method entirely.
Sorry, I didn't have an answer. 🙁
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply