October 27, 2009 at 1:30 pm
We have a webserver that is not part of our domain.
I need to pick up a mdf that is dropped randomly on the webserver, by external user.
The network administrator has given me these options to import the mdf,
ssh or https.
I've created a http connection manager, however I have not found a task that allows the connection. I've tried the Web Service Task, but I do not know what to put in the WSDLFile connection field.
My task is to pick up the MDF and attach the mdf to the data warehouse server.
Any help would be greatly appreciated.:blush:
October 27, 2009 at 2:15 pm
The problem with trying to write anything to do this is your statement that the file is placed in random locations on the web server. You need a consistent location to do this programatically.
October 27, 2009 at 2:19 pm
What I should of indicated was the mdf is in a specific folder, however the mdf is dropped randomly (no set date).
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply