Today on a demo i showed how to use the SharePoint List Source and Destination Adapters to load data into SharePoint from SQL Server.
Start by downloading the SSIS SharePoint adapter:
SharePoint List Source and Destination
Now start Business Intelligence Development Studio(BIDS) and choose to create a new SSIS Project:
Create a new Data Flow Task:
Drop a OLE DB Source and a SharePoint List Desination to the surface:
Configure the OLE DB Source to your SQL Database:
Now, configure your SharePoint List Destination like this:
Make sure that your column mappings look like this:’
Also make sure that the two shapes are connected.
I just created a list called “Sales Customers” in a SharePoint site and added list columns list this:
Now execute the package:
and watch the process:
And see how the data is transformed into a SharePoint list:
A really nice feature to get data into a SharePoint List using SSIS!