What would be the best way to call a web service "http://MyServer/LoadData" from a DTS package. I started to look at the VBScript and JScript but couldn't find a solution

Any help would be appreciated. Thanks

From within an Active Script you can use something like the Server XML HTTP
object from MSXML to make a HTTP GET or POST call, but for a WS with all the
associated SOAP wrappers to actually make sense of a it I suggest you write
your own COM object using a development tool that does all the hard work for
you. This object can then be leveraged from ActiveX Script. You could even
take this one step further and make this into a custom task.


--
Darren Green
http://www.sqldts.com



"omg" <anonymous (AT) discussions (DOT) microsoft.com> wrote

VBScript and JScript but couldn't find a solution.