Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
Juls
Yak Posting Veteran
51 Posts |
Posted - 2012-06-19 : 15:13:39
|
Hello, I can't seem to find anywhere straight forward examples on how to call (invoke) a web method from script task.
Here is what I have: 1. Created scrip task 2. Added web reference to my service. lets call it ABC_SERVICE 3. Added using System.Xml; using System.Web.Services; using System.Web.Services.Description; using System.Web.Services.Discovery; 4. Loaded my variables into script var enrollId= dts.variables["abc"].value
var legacyId= dts.variables["def"].value 5. NOW, how do I actually call to execute method of my service? my method name is UpdateMyId(Guid enrollId, int legacyId);
Thanks!!! |
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
Juls
Yak Posting Veteran
51 Posts |
Posted - 2012-06-19 : 15:54:12
|
Thanks.
Here is a stupid question.. i never did this and i am not sure where or how to "create a Proxy Class using WSDL from .NET command prompt" Where exactly is .net comand prompt?
pardon my ignorance |
 |
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-06-19 : 18:37:38
|
you'll have command prompt present as an option if you've installed visual studio .net
------------------------------------------------------------------------------------------------------ SQL Server MVP http://visakhm.blogspot.com/
|
 |
|
Juls
Yak Posting Veteran
51 Posts |
Posted - 2012-06-20 : 10:37:20
|
Ok, So I created the proxy class and added .cs and .config files to script. Now I am a bit fuzzy on the syntax to actually invoke the service and create a new webservice using c# |
 |
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-06-20 : 22:48:46
|
can you elaborate? whats the issue you're facing in invoking webservice?
------------------------------------------------------------------------------------------------------ SQL Server MVP http://visakhm.blogspot.com/
|
 |
|
|
|
|