I got a task where I need to pull data from a sharepoint list via SSIS package. By default, there is no provision to connect to sharepoint list. But, you can download the adapters from codeplex: http://sqlsrvintegrationsrv.codeplex.com/releases/view/17652
I have installed SSIS Sharepoint list adapters for SQL Server 2005. After you install the adapters, launch the SSIS BIDS. Create a new package. Open the Package window. Select the ‘Data Flow’ tab. In the left navigation, select the ‘Data Flow Sources’, right click and choose items. You will see a dialog window as shown below, where you can select the Sharepoint list source and destination adapters.
Now, after selecting the sharepoint list source and destination adapters, click on the Ok button. The adpaters will now appear on the toolbox as shown below,
thats all! now you can connect to sharepoint list via SSIS.