The SharePoint Source component allows you to retrieve tabular data from a SharePoint (2007 or later) list. Simply drag the component onto a data-flow and double-click the configure. The following interface is presented :



The first tab asks you to configure the HTTP connection to the SharePoint server, and the name (or GUID) of the associated list, as well as other connection parameters. Note that if your URL is incorrect and you are trying to access a list contained in a sub-site then you may get a spurious error from SharePoint about the list format being incorrect - lists can be specified in name form as long as the base site URL is correct.

Having configured our connection, the second tab allows us to select the columns that we want to return to the data-flow or filter upon. The columns available include internal system columns as well as user columns.  We can also specify simple equality filters on columns, which can be constant or a reference to a package variable. Only rows that match all equality filters configured will be returned. The name of the returned column will be the same as that in SharePoint by default, but you can adjust this and the column type if required using the 'Edit Name / Data Type...' button.