Friday, June 10, 2011

How To Add Share Point Transformation (Plug ins) on in the SQL Server 2008

1.What If the Source data is in Share Point List?How To Extract Data From the SharePoint List?
Share point Transformation is not coming with the SQL server 2008,we have to add this transformation manually. We can't add this transformation in SQL Server 2005.
Step 1. Down Load the SharePointListAdaptersSetup from the internet (freeware).Just execute the setup.
Step 2.Then Follow the Step Display in screenshot below.


Now You can Use share Point List Adapter Transformation as a Source in DFT(data flow task)

2:Now how to Work With the SharePoint List Transformation ?
Please Follow the ScreenShot below,and check the Highlited Points,you have to change only these Points.


No comments:

Post a Comment