KingswaySoft

SSIS Integration Toolkit for Microsoft SharePoint

The most comprehensive and robust data integration solution for managing SharePoint data and flat files

kingswaysoft - Microsoft SharePoint data integration made easy
SSIS Integration Toolkit for Microsoft Dynamics 365 Product Box - Package

Data Integration Made Easy

Powerful data integration for SharePoint utilizing SSIS ETL capabilities

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.

Robust Features

Unlimited Integrations

Powered by the powerful SSIS ETL engine, developers can quickly integrate Microsoft SharePoint with virtually any other application or data system.

Leverage unique capabilities to seamlessly integrate your SharePoint data with high-performing components designed for effortless connectivity to both SharePoint Online and On-Premises environments.

SSIS SharePoint Data Integration

Data Integration Made Easy

Advanced Integration Capabilities

  • Write to SharePoint lists and document libraries using 7 different write actions: Create, Update, Delete, CreateFolder, CheckIn, CheckOut, and Moderate.

  • Performant and easy-to-use SSIS components to quickly connect, read, and write to Microsoft SharePoint Online or On-Premises.

  • Option to retrieve data from SharePoint using CAML query filters built in the Query Designer, allowing you to design CAML Query directly within the SharePoint Source Component.

  • Support for downloading and uploading attachments in SharePoint list items.

  • Support for easy writing of various special SharePoint fields including taxonomy, lookup, and many other fields.

  • Support working with SharePoint document set with ease.

  • Upload and download documents with ease.

  • Support reading and writing flat files (CSV files) in your SharePoint document libraries using the 3 bonus SSIS components included.

  • Support both SOAP and REST APIs.

  • Support SharePoint modern authentication via OAuth connections.

  • Support for multi-threaded writing in the SharePoint destination component using one single configuration to facilitate high throughput writing.

  • The text lookup feature makes lookup painlessly easy, with support for in-place lookup using the text lookup feature that comes with many advanced features.

  • Manage SharePoint flat files with SSIS Productivity Pack's Premium Flat File Source, Destination and File Transfer Task, File Properties Task components included.

See Technical Requirements
See help manual for technical feature highlights

Codeless
 Integration

You don't have to write a single line of code to make data integration happen so your development can be done in a matter of minutes.

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 an extremely simple licensing model, our solution offers the best value for your investment.

Unparalleled
 Performance

Our software includes purpose-built features that help you achieve optimal performance while ensuring exceptional efficiency and reliability.

Data Integration Made Easy
SSIS Integration Toolkit for Microsoft SharePoint

Powered by modern cryptography and authentication technologies for secure connections, such as TLS 1.2, OAuth2, SHA-256, etc.

DownloadPurchaseHelp Manual

Great customer service and service response time. Answers all questions within a few hours. We have been using the SSIS Productivity Pack, the SSIS Integration Toolkit for Microsoft Dynamics 365 (CRM/AX/NAV), and the SSIS Integration Toolkit for Microsoft SarePoint. The Kingswaysoft components are extremely easy to use, and make programming SSIS packages a breeze!

Sean Graflund

Senior Software Developer

Guardian Alarm Company

Microsoft SharePoint SSIS Connection Manager

SharePoint Connection Manager

  • The SharePoint Connection Manager facilitates connection to Microsoft SharePoint web services.
  • Provides various authentication modes, including Windows Authentication and Username/Password, offering flexibility in connecting to SharePoint.
  • Supports connections to SharePoint on-premises and SharePoint Online (Office 365), enabling seamless integration with different SharePoint deployments.
  •  See this component's documentation

SharePoint Source Component

  • Allows you to read data from Microsoft SharePoint lists and document libraries in SSIS packages via web services.
  • Supports custom queries and filters, allowing users to extract specific SharePoint data based on their requirements.
  • Offers support for diverse SharePoint data types, including documents, list items, attachments, and metadata.
  •  See this component's documentation

Microsoft SharePoint SSIS Source Component

Microsoft SharePoint SSIS Destination Component

SharePoint Destination Component

  • Facilitates writing data to Microsoft SharePoint via web services using Create, Update, Delete or CreateFolder.
  • Supports bulk data insertion with comprehensive mapping capabilities, optimizing the upload process for large datasets to SharePoint and reducing processing time.
  • Enables incremental data loading, tracking changes since the last extraction for efficient data synchronization.
  •  See this component's documentation

Premium Flat File
Source Component

  • The Premium Flat File Source Component allows you to read data from a flat file in SharePoint.
  • Offers comprehensive support for various flat file formats, including CSV, TXT, and other delimited or fixed-width formats, enabling versatile data extraction capabilities.
  • Ensures optimized data retrieval performance, resulting in faster data loading and improved overall efficiency of SSIS packages.
  •   See this component's documentation

SSIS Integration Toolkit. Premium File Pack for SharePoint - Premium Flat File Source Component

SSIS Integration Toolkit. Premium File Pack for SharePoint - Premium Flat File Destination Component

Premium Flat File
Destination Component

  • The Premium Flat File Destination Component allows you to choose a file in SharePoint where the data will be written.
  • Supports custom data parsing and handling options for accurate flat file data processing, including specific column delimiters and data types.
  • Offers flexible column mapping options, allowing users to align SSIS data with specific columns in the flat file for accurate data insertion.
  •   See this component's documentation

Premium File Transfer
Task Component

  • Transfer and perform basic file system tasks: Send Files Delete Files, Create Directory, or Remove Directory.
  • Offers various secure file transfer protocols, such as FTP, SFTP, FTPS, and HTTP, ensuring data privacy during file transfers.
  • Enables scheduling and automation of file transfer tasks, allowing users to set up recurring transfers or execute them based on specific triggers and intervals.
  •   See this component's documentation

SSIS Integration Toolkit. Premium File Pack for SharePoint - Premium File Transfer Task Component

Data Integration Made Easy

Streamlined Development Experience

An extremely simplified ETL development experience within a familiar development environment (Microsoft Visual Studio) provides developers the best possible development productivity.

The user-friendly interface coupled with streamlined development processes ensures an intuitive and efficient ETL development experience.

Get the Ultimate Edition to start using all integration toolkits, including our SSIS Productivity Pack

DownloadPurchase

Where Our Solutions Fit in Your Workflow

Our solutions are used across a wide range of roles involved in managing
data pipelines, integrations, and enterprise system connectivity.

Data & Integration Engineers

  • Build pipelines using SSIS components

  • Connect APIs, files, and databases

  • Use a fully code-free interface

  • Log and handle integration errors

  • Improve performance with tuning

Enterprise Application Managers

  • Oversee scheduled integration tasks

  • Monitor recurring data sync workflows

  • Track execution of automation steps

  • Review integration run history logs

  • Check scheduled package performance

Solution Designers & Architects

  • Build reusable package templates

  • Enable high-volume data flows

  • Support hybrid system models

  • Align with audit and logging rules

  • Onboard new systems efficiently

More Resources

Download our Data Sheet for
SSIS Integration Toolkit for SharePoint

SSIS SharePoint Toolkit Data Sheet