SSDT will recognize the newly installed adapters and add them to the SSIS Tool Box automatically.Click OK Once that is done drag an "ADO.net" Destination from the SSIS Toolbox and connect the SP List Source to the Destination.SSIS is one of the widely used ETL tool which helps in moving data from one storage to another.
Updating sharepoint lists from ssis Horny chat room for free
Share Point Online Destination will allow user to push data in sharepoint list, source could be any source data storage type that SSIS supports.
Last week, Microsoft released the OData Source for Microsoft SQL Server 2012 . It allows SQL Server Integration Services (SSIS) to use an OData feed as a first class citizen data source in the same manner as SQL Server, Oracle, etc.
For more connection string examples, see Data Connections, Data Sources, and Connection Strings in Report Builder.
Credentials are required to run queries, to preview the report locally, and to preview the report from the report server.
This is a built-in data source type based on the Microsoft SQL Server Reporting Services Share Point List data extension.