KingswaySoft SSIS Integration Toolkit
kingswaysoft.com
- Free plan
- Windows
- API
- Self-hosted
What KingswaySoft SSIS Integration Toolkit is
KingswaySoft SSIS Integration Toolkit adds more than 300 components and tasks to Microsoft SSIS for connectivity, productivity, and ETL workflows without custom scripting. Teams build workflows using a drag-and-drop interface in Visual Studio or SSDT. Connectors cover business applications such as Salesforce, HubSpot, Shopify, and Dynamics 365, as well as JSON and XML, REST and SOAP APIs, cloud storage, and NoSQL databases. Additional tools include data anonymization, address verification, duplicate detection, profiling, PGP encryption, and compression. The toolkit supports Azure-SSIS Integration Runtime and SQL Server 2014, 2016, 2017, 2019, 2022, and 2025. It runs in self-hosted Windows environments, with .NET Framework 4.7.2 or later and SQL Server Integration Services listed as prerequisites. A free Developer License is limited to workstation development and attended, non-production execution. Paid licenses start at $699 a month. Commercial server licenses allow up to eight distinct connections per connection type, with the allowance resetting every 24 hours.
Who it suits
The toolkit suits teams building SSIS data integration and ETL workflows in Visual Studio or SSDT. Developers can use the free license for workstation development and attended, non-production execution.
Good to know, and what to watch
- Includes more than 300 SSIS components and tasks.
- Connectors cover business apps, APIs, and databases.
- Includes data profiling, encryption, and compression tools.
- Supports Azure-SSIS Integration Runtime and SQL Server 2014–2025.
- Paid licenses start at $699 a month.
- Free license excludes server operating systems.
- Free license excludes unattended and production execution.
- Requires .NET Framework 4.7.2 or later and SSIS.
Plans
Every plan and priceDeveloper License
Azure-SSIS IR License — Three-Months
Azure-SSIS IR — Three-Months
Single Server License — Three-Months
Free plan · 14-day trial
The verdict
KingswaySoft brings a wide set of integration and data productivity components into SSIS workflows. Check the license limits and prerequisites against your deployment needs before choosing a plan.
What the maker publishes
- Azure license limit
- The Azure-SSIS IR license is tied to the activated IR instance, is for Azure package executions, and supports up to one Instance Unit or two instance nodes. source
- Codeless workflow
- KingswaySoft describes drag-and-drop, no-custom-scripting construction for advanced ETL integrations. source
- Community complaint
- A Reddit discussion reports that some users needed custom C# Script Tasks for gaps in their integrations, while also crediting KingswaySoft with broad NoSQL, messaging and web-service coverage. source
- Company ownership and founder
- Crunchbase describes KingswaySoft as a private Oakville company and identifies Daniel Cai as founder and managing director; no funding total is shown there. source
- Company reach
- KingswaySoft says thousands of enterprise clients across more than 110 countries and regions use its solutions. source
- Company size and status
- LinkedIn lists KingswaySoft as privately held with 11–50 employees, headquartered in Oakville, Ontario, and founded in 2011. source
- Component library
- The toolkit contains more than 300 premium SSIS components and tasks. source
- Connection managers
- It includes more than 100 connection managers and prebuilt support for over 100 applications. source
- Current release
- The download page identifies version 26.2, released July 3, 2026. source
- Data productivity tools
- Listed components include data anonymization, address verification, duplicate detection, data profiling, PGP encryption, and compression. source
- Data quality tools
- Included groups contain address parsing and verification, data profiling, duplicate detection, diff detection, anonymization and data generation components. source
- Deployment environments
- Supported execution targets include on-premises SQL Server Integration Services and Azure-SSIS Integration Runtime. source
- Documentation
- The help manual provides installation guidance and component documentation spanning enterprise applications, REST, JSON/XML, cloud storage, big data, security and testing. source
- Free-license restriction
- The developer license is free for interactive development and debugging in Visual Studio or SSDT on a workstation, but server installations, unattended jobs and production execution require a commercial license. source
- Headquarters
- Oakville, Ontario, Canada source
- Integration coverage
- The product lists connectors for business apps such as Salesforce, HubSpot, Shopify, and Dynamics 365, as well as JSON/XML, REST and SOAP APIs, cloud storage, and NoSQL databases. source
- Integration formats
- Official materials list REST and SOAP APIs, JSON and XML, cloud storage, NoSQL databases, and business applications such as Salesforce, HubSpot and Dynamics 365. source
- Licence model
- The EULA and purchase page describe commercial subscription licences for a server or Azure-SSIS IR rather than an open-source licence. source
- License limits
- A single-server commercial license allows attended or unattended job executions and has no additional restrictions on features, users, or processors; it supports up to 8 distinct connections per connection type, reset every 24 hours. source
- Limit: documentation and setup
- Capterra reviewers say beginner documentation can be difficult and initial data-source setup can require effort. source
- Limit: errors and clunkiness
- Software Advice reviewers report freezes or errors caused by source-data changes, clunky workflows and occasional outdated adapters. source
- Limit: performance and debugging
- G2 reviewers report slowdowns with larger data volumes or multiple sources, difficult debugging and unclear errors. source
- Limit: underlying SSIS platform
- TrustRadius reviewers of SSIS cite slow real-time response, generic error messages, a dated or buggy Visual Studio experience, limited cloud/API functionality and weaker support for huge or nonrelational workloads. source
- Notable news: headquarters move
- KingswaySoft announced on August 29, 2024 that it would move its headquarters to 233 Speers Road, Suite 12, Oakville, Ontario. source
Checked against the maker's pages on 21 Oct 2026.