http://blogs.conchango.com/jamiethomson/ Jamie Thomson - Life, the universe and SSIS!

http://www.sqlis.com/

http://microsoftdw.blogspot.com/ Scott Barrett has begun a blog dedicated to implementing Microsoft BI technologies

Marcin Policht
Databasejournal
SQL Server 2005 - SQL Server Integration Services - Part 1 -12

Kirk Haselden blog - Development Manager for SQL Server Integration Services

SQL BI

Business Intelligence with SQL Server (by Marco Russo) 

SQLServerCentral.com

Examples of SSIS Variable Usage
If you want to know how to use variables to control your package flow go here: http://www.sqlis.com/default.aspx?306
If you want to use variables in expressions to set properties of a task (termed property expressions) then there's a nice example here of setting the SQLStatementSource property of an ExecuteSQL Task: http://blogs.conchango.com/jamiethomson/archive/2005/06/11/1593.aspx
or here of setting various properties of the SendMail task: http://www.sqlis.com/default.aspx?59
or here of setting the ConnectionString property of a FlatFile connection manager: http://blogs.conchango.com/jamiethomson/
explains how expressions can also be used in a variable: http://blogs.conchango.com/jamiethomson/archive/2005/03/19/1163.aspx

http://blogs.conchango.com/jamiethomson/ Jamie Thomson - Life, the universe and SSIS!

http://www.sqlis.com/

http://microsoftdw.blogspot.com/ Scott Barrett has begun a blog dedicated to implementing Microsoft BI technologies

Marcin Policht
Databasejournal
SQL Server 2005 - SQL Server Integration Services - Part 1 -12

Although this is based on the beta 3 it is a very good guide.

http://download.microsoft.com/documents/australia/windowsserversystem/sql2005/SQL05_Integration_Services.pdf

Local copy attached incase URL dissapears

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