dbTalk Databases Forums  

Web Service Task - Passing Variables as input

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Web Service Task - Passing Variables as input in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Dani
 
Posts: n/a

Default Web Service Task - Passing Variables as input - 08-29-2006 , 09:36 AM






Microsoft says it is possible but I just do not see how. Here is the
link to the help file where it said that variables could be pass as
input to web methods...I do not see the check box they mention on my
IDE.

Any help would be greatly appreciated.

Thanks,
Dani


Reply With Quote
  #2  
Old   
Charles Kangai
 
Posts: n/a

Default RE: Web Service Task - Passing Variables as input - 08-29-2006 , 04:28 PM






Yes, the documentation is correct. Once you have specified your WSDL and
specified the Service and Method on the Input page, a grid appears in the
lower part of the dialog box. The grid has a list of all the input parameters
of the webmethod, the data type and a column which has drop-down of all
variables available to the task. You can pick your variable from that
drop-down. You have to tick the checkbox in the Variable column to make the
drop-down appear.

You then click on the Output page and specify the variable or file that is
to contain the results of your webmethod.

Hope this helps.

Charles Kangai, MCT, MCDBA

Author of Learning Tree's 4-day course: "SQL Server 2005 Integration
Services" http://www.learningtree.com/courses/134.htm
Author of Learning Tree's 4-day course: "SQL Server Reporting Services"
http://www.learningtree.com/courses/523.htm





"Dani" wrote:

Quote:
Microsoft says it is possible but I just do not see how. Here is the
link to the help file where it said that variables could be pass as
input to web methods...I do not see the check box they mention on my
IDE.

Any help would be greatly appreciated.

Thanks,
Dani



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.