Accessing SharePoint Lists with SQL Server Integration Services SSIS 2005

As now a days, sharepoint has become very propular and is widely used. And people come acorss the requirements to make share point communicate with SQL server; to & fro. And there may be need to load data from share point applications to some database and vice versa; without much of extra coding efforts.

In other words we may want to access data of share point application to manipulate/operate on, which can be in some other formats other that simple database tables like lists/docs etc.

I found a very nice & simple aritcle which manages to access the list data of sharepoint Lists using SSIS, so that we can do whatever operations we want to do with those data in SSIS by using in built SSIS features  like transformations etc.

Here is the link

 

http://www.mssqltips.com/tip.asp?tip=1723

Advertisements
This entry was posted in Others, SQL Server, SSIS. Bookmark the permalink.

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