sql server dts: I have an w2ksql db running on a shared server,.
I have been asked to use RPC calls into a NON MS server to Upload orders and
download stock reports.
I dont have a clue where to start, can anyone sugest some direction to go in
either research or samples etc..
They will give me a login and password to access the system but have no
knowledge of uploading/ downloadin xml files using RPC.
Any advice or assistance would be more than greatfully accepted.

Regards
Don

Don,
This question is to broad. Do you have a problem with connecting to a
remote server, a NON-SQL Server platform, transferring data or reading
XML?
If it's all of the above, then it is unlikely someone here will be able
to help you...

Tnx,

Hans Brouwer

*** Sent via Developersdex http://www.developersdex.com ***

Hans
Im fishing for more information as its outside my area of expertise (at the
moment)
The actual problem is that I dont know what im talking about and Im trying
to get som hints on where to start.
What I now understand is that I have to use HTTP POST and exchange xml
documents from a third party automated from sql2k.
Looks like im going to have to contract the work out as time constraints
will not allow me to gain enough comercial experience.
But I am looking for offers 8-)

Regards
Don



[quoted text, click to view]

In article <#QPh#A#nDHA.2732@TK2MSFTNGP11.phx.gbl>, Don Grover
<spamfree@assoft.com.au> writes
[quoted text, click to view]

Use the ServerXMLHTTP component included in MS XML 4. Here is a simple
sample of a GET request as you might perform one inside an ActiveX
Script Task in DTS. It supports POST as well, so you can send and
receive. It is also fully aware of XML which is nice if that is what you
are transferring.

Get the MSXML SDK (help file) or search MSDN for full details of
ServerXMLHTTP.


Dim xmlHTTP
Dim sURL

sURL = "http://someotherserver/respond.asp?Param1=" &
DTSGlobalVariables("MyVar").Value

Set xmlHTTP = CreateObject ("MSXML2.ServerXMLHTTP.4.0")
xmlHTTP.open "GET",, False
xmlHTTP.send ()
MsgBox xmlHTTP.responseXML.xml




--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org