SSIS Integration Toolkit logo

SSIS Integration Toolkit

by KingswaySoft · Since 2011
No reviews yet
ActiveAvailable globallyCloudOn-premise
Quick facts
VendorKingswaySoft
Year launched2011
StatusActive
Location233 Speers Road, Suite 12 Oakville, ON L6K 0J5 Canada
Countries servedGlobal
Languages9
Integrations72+
Free tier
Free trial
Contact sales

About SSIS Integration Toolkit

[API Error: HTTPSConnectionPool(host='api.openai.com', port=44]

The SSIS Productivity Pack is a comprehensive suite of premium SSIS components designed to enhance developer productivity and simplify advanced integrations. It is built for users looking to streamline ETL processes, offering over 300 powerful components that significantly improve the functionality and performance of SQL Server Integration Services (SSIS). The software provides tools to quickly handle complex data transformations, integrations, and manipulations with ease, catering to various data processing needs across a range of industries. The user interface is intuitive and designed to allow users to seamlessly integrate and manage their data transformations without the need for custom scripting. The drag-and-drop functionality ensures that even those with limited coding experience can easily leverage the full potential of the SSIS platform. The tools are designed to be compatible with SQL Server Integration Services across multiple versions, including SQL Server 2022, 2019, 2017, 2016, 2014, and 2012. It also supports deployment to the Azure-SSIS Integration Runtime, making it a versatile choice for both on-premises and cloud-based environments.

Pros & Cons

What users like
  • +Easy to use, with a free version available for experimentation.
  • +Simplifies integration and enhances IT environment.
  • +Helpful toolkit for mapping and utilizing features with integrated systems.
  • +Seamless connection to other sources and targets.
What users flag
  • View changes when editing, sometimes causing errors.
  • Difficult to find solutions online, with outdated articles and poor UI.
  • Documentation can be hard to understand, assuming users know data integration.
  • Freezes due to source data issues, requiring guesswork to fix.

Features

Key features

Premium Data Components
A suite of advanced components that enhance the data integration capabilities of SSIS, helping users streamline ETL processes without custom scripting.
No Custom Scripts
Over 300 components that facilitate rapid development and ensure that developers do not need to write custom scripts for common data integration tasks.
Expanded Native SSIS
Builds upon native SSIS components to offer new features with improved performance and easier-to-use interfaces.
Integration with OData RESTful APIs
Simplifies data integration with OData APIs, allowing users to read from and write to OData endpoints effortlessly.
Excel Integration
Work with Excel data seamlessly in both 32-bit and 64-bit environments without additional configuration.
JSON & XML Processing
Easily bring data from JSON and XML documents into SSIS using dedicated source or extract components.
Data Anonymizer
Anonymize sensitive data before it enters UAT environments to ensure compliance with privacy regulations.
Address Verification
Batch address verification to ensure data accuracy across your datasets.
Premium Slowly Changing Dimension
Simplifies the creation and management of Slowly Changing Dimensions (SCDs) in SSIS.
PGP Encryption
Secure data by encrypting or decrypting files within the SSIS control flow.
Google Services Integration
Directly access Google Ads and Google Analytics data from within SSIS workflows.
SFTP/FTPS Support
Easily connect and integrate with SFTP and FTPS servers within SSIS to transfer files securely.

Additional features

Premium Derived Column
Unleashes the full power of SSIS expressions, making it easier to apply complex transformations.
Data Spawner
Quickly generate sample data for testing and development without manual input.
Premium ADO.NET
Go beyond basic operations like Insert and Update, enabling Upsert and more complex operations with ADO.NET.
Duplicate Detector
Detect and remove duplicates from your data using configurable matching algorithms.
Diff Detector
Compare two data sources and highlight differences at the row level.
Message Queue Integration
Simplify the integration of various message queue services without writing custom code.
FTP/FTPS/SFTP Support
Connect to FTP, FTPS, or SFTP servers with ease for file transfers.
Compression Task
Compress files using the built-in Compression Task for more efficient data storage.
Email Integration
Retrieve emails from POP3, IMAP, or Exchange servers and process them within SSIS.
SMTP
Set up automated email notifications to receive SSIS job execution summaries.
Template Merge
Perform text or HTML content merges with SSIS columns or variables using an easy-to-use UI.

Pricing

Free trial
Free version
Request a quote
Promo Offer

Countries & Languages

Global
Countries served
9
Interface languages
1
Billing currencies

Interface languages

EnglishFrenchSpanishGermanItalianPortugueseChineseJapaneseKorean.

Billing currencies

🇺🇸USD

No reviews yet

Be the first to drop a review

Alternatives to SSIS Integration Toolkit

Smartlink Data Connector logo

Smartlink Data Connector

Smartlink Data Connector (SDC) is a robust interoperability platform designed to solve one of healthcare’s…

Portus Platform logo

Portus Platform

Portus Platform is a robust logistics and trade facilitation solution designed to modernize complex supply…

Riva CRM Integration logo

Riva CRM Integration

Riva CRM Integration is a robust enterprise-grade platform designed to bridge the gap between communication…

Ledgerflow logo

Ledgerflow

LedgerFlow is an emerging AI-powered accounting solution designed to simplify financial management for modern businesses.

SKUplugs logo

SKUplugs

Skuplugs is a practical integration solution designed to bridge the gap between physical retail systems…

M

Metrolink

Often compared with SSIS Integration Toolkit

Compare any two tools →
Smartlink Data Connector logo
Smartlink Data Connector
Integration
0.0
Portus Platform logo
Portus Platform
Integration
0.0
Riva CRM Integration logo
Riva CRM Integration
Integration
0.0
Ledgerflow logo
Ledgerflow
Integration
0.0