Howdy!

We run into a problem when we wanted to use the "Web Service Task"
from SSIS (SQL Server Integration Services) to access the web services
offered by WSS 3.0 (Windows SharePoint Services 3.0).

Although the generated WSDL file for list items
(http://answer42/_vti_bin/lists.asmx?WSDL) was generated OK, as soon as
we wanted to use this WSDL file with the "Web Service Task" from
SSIS the following messages appeared:

This version of the Web Services Description Language (WSDL) is not
supported.

It seems that this is a common error as similar problems are also
reported here:

http://groups.google.de/group/micros...f596d62?lnk=st

http://groups.google.de/group/micros...54cd5a88087660

Basically, it drills down to the error "Type
'http://microsoft.com/wsdl/types/:guid' is not declared" which is
linked to http://support.microsoft.com/kb/317611/en-us However, the
description in the KB article does not really help.

We have now solved this problem by patching the generated WSDL of WSS
on the following location:

<s:element name="AddListFromFeature">
<s:complexType>
<s:sequence>
<s:element minOccurs="0" maxOccurs="1" name="listName"
type="s:string" />
<s:element minOccurs="0" maxOccurs="1" name="description"
type="s:string" />
<!--<s:element minOccurs="1" maxOccurs="1" name="featureID"
type="s1:guid" />-->
<s:element minOccurs="1" maxOccurs="1" name="templateID"
type="s:int" />
</s:sequence>
</s:complexType>
</s:element>

The item "featureID" which is declared as GUID and that is causing
the error was simply commented out. Now everything works as expected.

I hope this information is of some use.

Michael 'TeX HeX' T.
http://www.texhex.info/