all groups > sql server dts > may 2007 >
You're in the

sql server dts

group:

Calling Web Service From Script Task


Calling Web Service From Script Task Kiran
5/9/2007 10:47:14 PM
sql server dts: Hi All,
Is there any way that I can call a web service inside a Script task in
SSIS package? I'm not able to add Web reference inside the script
task :(

I know a liitle abt the Web Service task, but I want to pass a XML
Document as parameter to web service and the script task is creating
the XML Document, So instead of saving it in a temp location, is there
any way that I can send the XML from script task itself?

Or Can I store the resultant XML to a variable, so that I can use the
variable in the web service? I tried this way, but attempt was
unsuccessful

Any help will be highly appreciated.

Regards
Kiran
Re: Calling Web Service From Script Task Allan Mitchell
5/11/2007 8:03:45 PM
Hello Kiran,

Why would you not use the Web Service Task?

http://msdn2.microsoft.com/en-us/library/ms140114.aspx



--

Allan Mitchell
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
http://www.konesans.com

[quoted text, click to view]

AddThis Social Bookmark Button