Powerful Microsoft SharePoint data integration is possible with the SSIS Integration Toolkit for Microsoft SharePoint.

 With this high-performance, easy-to-use, cost-effective data integration solution built on the SSIS ETL engine, developers can use the skill-set they already know to quickly build effective SSIS data integration packages for SharePoint and any other application or database system.

The SSIS Integration Toolkit for Microsoft SharePoint

  • Performant and easy-to-use SSIS components to quickly connect, read and write to Microsoft SharePoint Online or On-Premise.
  • Take advantage of the freedom, flexibility and power of the SSIS ETL engine to facilitate Microsoft SharePoint data integration.
  • Quick integration development and scheduling that can be done in minutes.
  • Facilitates reading/writing data to/from Microsoft SharePoint Lists and Document Libraries via web services using SSIS.
  • Includes any hidden lists and fields.
  • Quickly and easily create simple to complex SSIS integration or migration jobs.
  • Read data from SharePoint using CAML query filters built in the Query Designer.
  • Manage your SharePoint flat files with 3 bonus SSIS components included with the toolkit.
  • Integrate your SharePoint data with virtually any application or database system including Microsoft Dynamics 365, Salesforce, Marketo, SQL Databases and Oracle Databases using our SharePoint SSIS components.
  • Available on its own or as part of a package with our other enterprise data integration solutions in our Ultimate Edition.
SharePoint SSIS Data Integration
  • fill

    SSIS Integration Toolkit for
    Microsoft SharePoint

    The most comprehensive and robust data integration
    solution for SharePoint

  • fill

    Codeless Integration

    You do not have to write a single line of code
    to make data integration happen; your development
    can be done in a matter of minutes, which would
    otherwise take weeks or even months

    Unparalleled Performance

    Our software offers many specifically designed
    features that help you achieve the best possible
    data integration performance, while rescuing your
    IT budget

    Flexible and Easy to Use

    We make the most flexible integration solution
    on the market. Our software offers intuitive user
    interfaces that are flexible and easy to use

    Cost Effective

    With a streamlined development experience,
    and a simplified licensing model, our solution
    offers the best value for your investment

  • fill

    The KingswaySoft tool’s UI is
    very intuitive and you cannot beat
    the support they provide.

    D.Ng Senior DBA, ASCO
  • fill
    Support for



How To Integrate Data into SharePoint

CRM to SharePoint Data Integration with SSIS
  • Establish a connection to your Source System.
  • Drag out the Source Component for you desired source and select the fields you would like to retrieve data from.
  • Establish a connection to your SharePoint instance using the KingswaySoft SharePoint Connection Manager.
  • Drag out the KingswaySoft SharePoint Destination Component and connect your source component to it.
  • Select the destination list and your write action, then use simple drop-down menus to map the source input columns to their SharePoint Fields.
  • Execute your task!

Unique Features

  • Write to SharePoint lists and document libraries using 7 different write actions: Create, Update, Delete, CreateFolder, CheckIn, CheckOut, and Moderate.
  • Support for downloading and uploading of attachments in SharePoint list items.
  • Support for multithreaded writing using one single configuration.
  • Query Designer allows you to design CAML Query directly within the SharePoint Source Component.
  • Manage SharePoint flat files with SSIS Productivity Pack's Premium Flat File Source, Destination and Transfer Task components included.

SharePoint SSIS Components

Technical Requirements

  • Microsoft SharePoint
    • Microsoft SharePoint 2016
    • Microsoft SharePoint 2013
    • Microsoft SharePoint 2010
    • Microsoft SharePoint 2007
    • Microsoft SharePoint on Office 365
  • SQL Server
    • Microsoft SQL Server 2017
    • Microsoft SQL Server 2016
    • Microsoft SQL Server 2014
    • Microsoft SQL Server 2012
    • Microsoft SQL Server 2008 R2
    • Microsoft SQL Server 2008
    • Microsoft SQL Server 2005