SharePoint List and SSIS SQL Server (Loading data into SahrePoint List)

Create a Test Package in SSIS
Create a Data flow Task and rename it to ToSharePointList

Using SQL Server SSIS for Loading data into SharePoint List

1. Double click the task and open the Data Flow
2. Add a Flat File Source and Configure (This files should have compatible fields as per your SharePoint List)
3. Add SharePointListDestination from Tool box
4. Right click on the item and click edit
5. Add the Site URL: http://Vijay// (Ex: This is the name of my URL http://Vijay/Lists/EmpContactAdvWorks/AllItems.aspx)
6. 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)
7. Go to Column Mapping and <Refresh> and Click OK
8. Execute the package
9. Go to the SharePoint site and check the list for the data
10. Screen Shot follows: