JG Vimalan's Blog

It is all about coding!

Connect to Sharepoint list via SSIS

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.

Advertisements

March 29, 2011 - Posted by | SharePoint, SSIS 2005

1 Comment »

  1. thanks dude! I was searching for this and you have given a clear information. Keep up the good work!

    Comment by henry | April 5, 2011 | Reply


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: