• One single solution that works
Microsoft SharePoint, including 2016,
2013, 2010, 2007, Oce 365.
• The toolkit helps you manage all the
intricate details involved in working
with Microsoft SharePoint model.
• Easy learning curve, consistent
application interface, familiar
development experience within
SQL Server Business Intelligence
development environment (Visual
Studio.
• Free developer license is available
for any interactive use without any
limitations.
• Microsoft SharePoint 2019
• Microsoft SharePoint 2016
• Microsoft SharePoint 2013
• Microsoft SharePoint 2010
• Microsoft SharePoint 2007
• Microsoft SharePoint Ofce 365
• Azure SQL
• Microsoft SQL Server 2022
• Microsoft SQL Server 2019
• Microsoft SQL Server 2017
• Microsoft SQL Server 2016
• Microsoft SQL Server 2014
• Microsoft SQL Server 2012
KingswaySoft is a leading provider of
data integration solutions for enterprise
software. Organizations from more than
90 countries rely on our solutions to drive
their business data eciency.
Our primary mission is to help our
customers to be successful in their
business by providing them with quality
software products and innovative
integration solutions at a competitive
price.
The is a cost-effective, easy-to-use and high-
performance data integration solution for Microsoft SharePoint, utilizing Microsoft SQL Server
Integration Services (SSIS) as the ETL platform and data load engine.
Data Integration Made Easy
The ultimate goal of the toolkit is to simplify your data integration development work. By utilizing
Microsoft SQL Server Integration Services (SSIS) as your data integration platform, you can take
advantage of the exibility and power of SSIS ETL engine, which enables integration with virtually
any application or data source that you may need to work with.
Key Features
• Support for reading/writing data to/from Microsoft SharePoint Lists and Document Libraries
via web services
• Capability to read/write to hidden SharePoint Lists and Document Libraries
• Refresh Component button to retrieve latest metadata from the SharePoint server
• Starting with the Free Developer License for any interactive use, we offer the most exible
licensing model
• In addition to the below components also includes the Premium File Pack Source, Destination
and File Transfer Task components.
Main Components
• Option to work around intermittent errors by making
retry service calls.
• Support for subsite connection through Service URL
• Facilitates reading data (including hidden lists and
elds) from Microsoft SharePoint server.
• Capability to perform data ltering through
CAML Query Filter with additional support for
parameterizing your query using SSIS variables.
• Document Scope feature to specify how to read from
Document Libraries.
• Option to download attachments and documents by
saving to a le system or to create an SSIS output data
column for the downstream pipeline components.
• Option to specify available Source View when reading from
SharePoint Lists.
• Support for Create, Update, Delete, CreateFolder, CheckIn,
CheckOut and Moderate write actions.
• Support for uploading of attachments for SharePoint.
• Batch Size option to specify how many records to submit to
the SharePoint web service each time.
• Advanced ltering capabilities for SharePoint eld mappings.
• Support for multithreaded writing using one single conguration.
• Text Lookup feature available when working with lookup elds including lookup references from different
subsites.
• 3 Error Handling Mechanism with congurable additional column (SharePoint_ID).
Microsoft SQL Server and Microsoft SharePoint are trademarks of Microsoft Corporation.
This document is for informational purposes only. KINGSWAYSOFT MAKES NO WARRANTIES, EXPRESS OR IMPLIED, IN THIS DOCUMENT.
www.kingswaysoft.com
SSIS INTEGRATION TOOLKIT FOR
MICROSOFT SHAREPOINT