Learn more
 

CData Software - Knowledge Base



Recent SharePoint SSIS Articles

Export Data from SQL Server to SharePoint through SSIS

Easily push SQL Server data to SharePoint using the CData SSIS Tasks for SharePoint.

Back Up SharePoint Excel Services to SQL Server through SSIS

Easily back up data to SQL Server using the CData ADO.NET Provider for SharePoint Excel Services. This example uses an SSIS workflow to populate a database with SharePoint Excel Services.

Perform API Operations Using Stored Procedures in CData SSIS Components

The CData SSIS Data Flow components allow you to easily import and export data from various data sources. However, in some cases, the type of operation you need does not fit the SSIS Data Source or the SSIS Data Destination model. In this article, we will demonstrate how to use a CData stored procedure in your SSIS Data Flow.

Connect SharePoint to SQL Server through SSIS

Easily back-up SharePoint data to SQL Server using the SharePoint Data Provider for ADO.NET. This example uses an SSIS workflow to populate a database with SharePoint data using the SharePoint ADO.NET Data Provider.

Use the CData SSIS Components to Insert New or Update Existing SharePoint Excel Services Records from SQL Server

Easily push SQL Server data to SharePoint Excel Services using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into SharePoint Excel Services or update existing records with data from a SQL Server database.

Download files from a SharePoint site using the CData SSIS Components

The CData SSIS data flow components allow you to easily import and export data from various data sources. However in some cases the type of operation you need does not fit the SSIS Data Source or the SSIS Data Destination model. In this article, we will demonstrate how to use a CData stored procedure in your SSIS data flow.

Perform API Operations Using the CData SharePoint Task

The CData SharePoint Task allows you to easily call stored procedures to perform SharePoint API operations.

Use the CData SSIS Components to Insert New or Update Existing SharePoint Records from SQL Server

Easily push SQL Server data to SharePoint using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into SharePoint or update existing records with data from a SQL Server database.

Import SharePoint Data into SQL Server using SSIS

Easily back up Microsoft SharePoint to SQL Server using the SSIS components for SharePoint.

Import SharePoint Excel Services Data into SQL Server using SSIS

Easily back up SharePoint Excel Services to SQL Server using the SSIS components for SharePoint Excel Services.