http://www.sqlteam.com/item.asp?ItemID=21502

In trying to connect SQL2005 SSIS to Sharepoint Lists, this article is very helpfull on the mechanics of programatically retrieving data from sharepoint

With the advent of the Web Service Task in SQL2005 Integration services I had high hopes that integration of Sharepoint Lists (via the Sharepoint Web Services) would be easy to achieve, but it seems I was wrong.

Whilst the Web Service Task happily gets simple definitions of lists, when it comes to handling Web services with complex XML type parameters then it just gives up and gives an error.

An example of a Sharepoint Web Service it cant cope with is the GetListItems Method, amongst one of it's parameters it takes viewFields complex type and the Web Service Task just gives up.

viewFields   A ViewFields element that specifies which fields to return in the query and in what order, and that can be assigned to a System.Xml.XmlNode object, as in the following example:

<ViewFields>
   <FieldRef Name="ID" />
   <FieldRef Name="Title" />
</ViewFields>
 
and the WSDL definition for this is
 
-- <s:element minOccurs="0" maxOccurs="1" name="viewFields">
- <s:complexType mixed="true">
- <s:sequence>
  <s:any /> 
  </s:sequence>
  </s:complexType>
  </s:element>
 
 
There seems to be very few examples of people who have tried this although the following articles from rdoherty's WebLog and Klaus Salchner were helpfull.
 
Can anyone assist in suggestions as to how to overcome this ?

And interesting article by Paul Schaeflein in a series of real world examples of implimenting Sharepoint in the real world

http://www.intranetjournal.com/articles/200504/pij_04_06_05a.html

Freedom and whisky gang thegither wrote Robert Burns over two hundred years ago.

Ive been invited for an evening at the society 21st and I'll report back (if I can remember on my recommendations)

http://www.smws.co.uk/venues/greville_st.php

Be sure to visit all the options undfer "Configuration" in the Admin Menu Bar above. There are 16 themes to choose from, and you can also create your own.

http://oem.microsoft.com/script/contentpage.aspx?pageid=551794

Items from gates keynote to follow up on

Linksys media extender

Xbox Extender

Creative nuvo slim 256 & Zen micro – I river H320 – Samsung – Real Carbon hdd device - Dell Pocket DJ 5Gb -

- portable media centre -

Toshiba – http://www.qosmio.co.uk/

Entertainment centres

HP Digital Entertainment Center Launch 2004

Gateway Media Center PC 500 Series

HP removeable drives & photo printer

Dell AX50 

The Dana Owens Album– music

http://www.microsoft.com/uk/partner/default.aspx

http://oem.microsoft.com/script/contentpage.aspx?pageid=551794

Items from gates keynote to follow up on

Linksys media extender

Xbox Extender

Creative nuvo slim 256 & Zen micro – I river H320 – Samsung – Real Carbon hdd device - Dell Pocket DJ 5Gb -

- portable media centre -

Toshiba – tablet

Gateway and HP music centres

HP removeable drives & photo printer

Dell AX50 

The Dana Owens Album– music

http://www.microsoft.com/uk/partner/default.aspx

http://www.abbyy.com

This took place in the Grandstand and Phyliss Court Club, Henley.  A donation to the William Yeoman Cancer Care Trust was made for over £500.

Entertainment by "Soul Purpose" Jazz band made up of musicians from Local Marlow Schools

Caberat by Mr Graham P. Jolley - Mysticist !

It was my pleasure to attend this event at the Complete Angler in Marlow with my wife, Nicki and Reg Senda and Lady Anne Redgrave.  A good night was had by all.

http://reviews-zdnet.com.com/Internet_Phones/4520-9140_16-5131535-1.html?tag=glnav