August 12, 2005 at 8:09 am
Okay, this one might stump you guys.
This involves a SIS project.
I am trying to access a web service that has parameters (three of them, all strings). But I want to access this service repeatedly, and drive the thing from a table.
I've got the Foreach Loop correctly getting variables from the recordset I populate from the table. That works and I can run a script with msgbox showing all the correct values being read from the table.
My problem is taking these variables and sticking them in the Name / Type / Value entries in the Input tab of the Web Service Task. There doesn't seem to be any mechanism for dynamically updating these at runtime, and if there isn't, that is a HUGE hole in the product. Who accesses Web Services with the same parameters every time??!?
August 15, 2005 at 8:00 am
This was removed by the editor as SPAM
August 31, 2005 at 10:44 am
Larry,
You're right, this can't be done and I agree that this is a big hole. Microsoft's stock answer is that BizTalk should ideally be used for integrating with Web Services but I dare say that this will be changed (possibly in a service pack update) because alot of people have complained about it (including myself).
Property expressions can't be used because the properties that you want to change are not constant - they vary depending on which web service you are using.
-Jamie
Jamie Thomson
http://sqlblog.com/blogs/jamie_thomson
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply