sql server dts: 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

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





[quoted text, click to view]