SharePoint List and SSIS SQL Server (Retrieving data from SahrePoint List)

Retrieving Data from SharePoint List using SQL Server SSIS

1. Create a Test Package in SSIS
2. Create a Data flow Task and rename it to FromSharePointList
3. Double click the task and open the Data Flow
4. Add SharePointListSource from Tool box
5. Right click on the item and click edit
6. Add the Site URL: http://Vijay// (Ex: This is the name of my URL http://Vijay/Lists/EmpContactAdvWorks/AllItems.aspx)
7. Add the Site List Name: Name of the List you want to copy to a Flat-File (Ex:This is the name of my list EmpContactAdvWorks)
8. Go to Column Mapping and <Refresh> and Click OK
9. Now add a Flat-File destination and double click to configure
10. Create a new Flat File destination and Map the fields
11. Run the Package
12. Screen Shot follows: