Use SharePoint List Data Source and Destination

There are many scenarios when we need to pull data from SharePoint List.

I have done this many times but by Querying SharePoint Database.

Curtsy to following blogs –

http://weblogs.sqlteam.com/jhermiz/archive/2007/08/15/60288.aspx

Now we have something called SharePoint List Source and Destination available. This makes my job quit easy. Following is reference for the same -

http://msdn.microsoft.com/en-us/library/dd365137(SQL.100).aspx

Good thing is same kind of source are available at Reporting level as well so you can create reports on SharePoint List Data .. Following is reference for same

http://msdn.microsoft.com/en-us/library/ee633650.aspx