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 tierN/A
Free trialN/A
Contact salesN/A

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

Pros
  • 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.
Cons
  • 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…

Partner Fleet logo

Partner Fleet

Partner Fleet is a no-code platform for building and managing app marketplaces, partner directories, and…

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…

Spot something wrong or outdated?

Suggest a correction — a reviewer verifies every change.

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
Partner Fleet logo
Partner Fleet
Integration
0.0
Riva CRM Integration logo
Riva CRM Integration
Integration
0.0