Advanced SSIS components that meet all your integration needs

Over 125 SSIS components designed to enable the greatest SSIS development productivity and advanced flexibility. Simplify the development of even the most complex SSIS ETL requirements and integrate with any application or database system without writing a single line of code.

The SSIS Integration Toolkit brings more power to SSIS with dozens of premium and unique components added to SSIS to make data integration easy. With our advanced SSIS add-on components developers are equipped with more potentials within SSIS than ever before to create simple to complex integration jobs quickly and easily.

Productivity Enhancements for SSIS

All of our productivity enhancement components are found within the SSIS Productivity Pack, a premium collection of SSIS components every developer needs in their toolbox.

Download my free copy of the SSIS Productivity Pack.
No credit card, no contact form, just download and go

Expands on the features and functionality of the out-of-box Derived Column component to create a component with greater potentials, features, and ease-of use. Offers over 200 functions and an advanced expression editor. Learn More.
Combines the functionality of the out-of-box Lookup and Fuzzy Lookup components into one simplified, easy to use component. The Premium Lookup component allows for any data input as the lookup source and includes several additional matching options without any deployment limitations. Learn More.
An enhancement on the SSIS out-of-box component which creates an extremely easy development process without limitations. The component can process three types of slowly changing dimensions: Fixed Attributes, Changing Attributes and Historical Attributes. Lean More.
Compares the fields from two sources to determine if rows are changed, unchanged, delete or added based on user selected primary key(s).
Compares rows within a data source to identify duplicate rows based on a fuzzy or exact match. The Duplicate Rows output contains additional fields for further processing.
Connection: Facilitates connection to local Excel files with support for password encrypted files.

Source: An enhanced Excel source, this premium components allows developers greater flexibility with the excel file set-up with support for specifying which row you want to start reading data from, how many rows you would like to retrieve and more.

Destination: An enhanced Excel destination component, this premium component gives developers great flexibility in how data should be written to the excel file such as writing new data, overwriting existing data, adding to the end, or writing to specific rows as well as many other additional features.
Connection: Facilitates connecting to Azure Service Bus from within SSIS.

Source: Enables developers to quickly and easily to read Azure Service Bus Queue or Topic data with support for custom fields.

Destination: Enables developers to quickly write to Azure Service Bus entities. Developers have the option to write to Queue, Topic, or Event Hub entities with full control on how they would like the data to be written to the queue.
Connection: Facilitates connection to Microsoft Message Queue from within SSIS.

Source: Enables developers to quickly read from a Microsoft Message Queue through a Peak or Receive and Delete receiving modes.

Destination: Enables developers to quickly send messages to a Microsoft Message Queue. Developers have the option to specify how messages should be added to the queue as well as the priority level and lifespan of the message.
Connection: Facilitates connecting to RabbitMQ messaging queue from within SSIS.

Source: Enables developers to quickly read from RabbitMQ through Peak or Receive and Delete receiving modes.

Destination: Enables developers to quickly send messages to RabbitMQ. Developers have the option to specify how messages should be added to the queue as well as the selecting the priority level and the message body encoding method.
Source: Retrieve data from JSON documents through HTTP requests or files. Supports extracting from any REST-based API.

Extract: A transformation component which extracts data from JSON documents to enable the use of using JSON as a source within SSIS.

Merge: An SSIS transformation component that facilitates transferring and merging data into JSON format with several options to control how the data should be inputted and formatted.

Destination: Merge data into JSON format and write it to any file or send it as an HTTP request to any REST-based API.
Source: Retrieve data from XML documents through HTTP requests or files. Supports extracting from any web service.

Extract: An SSIS transformation component that supports extracting column data from XML documents to use XML data as a source. Supports importing example XML document or an XSD schema with manual refinement to generate the expected hierarchy.

Merge: An SSIS transformation component that facilitates transferring and merging data into XML format with several options to control how the data should be inputted and formatted.

Destination: Merge data into XML format and write it to any file or send it as an HTTP request to any web service.
Merge column and variable data into an HTML template through a WYSIWYG or source editor.
Merge column and variable data into a text template.
Connection: Supports connecting to an IMAP, POP3, or Exchange Web Services mail server in SSIS.

Source: Receive emails from a mail server and outputs them into columns.
Connection: Enables developers to connect to an SMTP server within SSIS.

Destination: Enables developers to send emails within the data flow using column data.

Task: Used to send emails to predefined recipient(s) within the Control Flow.
Connection: Used to establish a connection to Dropbox from within SSIS.

Source: Facilitates retrieving data from Dropbox with various item retrieval modes such as retrieving files and folders, only files, or choosing whether sub-items should be included.

Destination: Facilitates writing data to Dropbox through Create, Delete, Move or Upsert write actions.
Connection: Used to establish a connection to Microsoft OneDrive from within SSIS.

Source: Facilitates retrieving data from OneDrive with various item retrieval modes such as retrieving files and folders, only files, or choosing whether sub-items should be included

Destination: Facilitates writing data to OneDrive through Create, Update or Delete write actions
An SSIS transformation component for converting a date column from one timezone to another.
Source: A premium version of the SSIS ADO.NET Source component to include improved metadata handling and greater support for many different data providers.

Destination: A premium version of the SSIS ADO.NET Destination component which offers support for more data providers and all write actions (Insert, Update, Delete, and Upsert).

Learn More
Connection: Facilitates the connection to an Amazon DynamoDB server from within SSIS.

Source: Retrieve data from Amazon DynamoDB server, includes the ability to output data to JSON format.

Destination: Write data to an Amazon DynamoDB server through Insert, Update, Upsert, or Delete actions.
Connection: Facilitates the connection to an Apache Cassandra server from within SSIS.

Source: Retrieve data from Apache Cassandra server, includes the ability to generate CQL commands to filter data.

Destination: Write data to a Cassandra server through Insert, Update, Upsert, or Delete actions.
Connection: Facilitates the connection to a MongoDB server from within SSIS.

Source: Retrieve data from MongoDB server with several advanced filtering capabilities for further data retrieval refinement.

Destination: Write data to a MongoDB server through Insert, Replace, Update or Delete actions with the option to use Upsert on Replace and Update actions. The component also includes several advanced options such as Filter String and Projection Mapper.
Connect to an FTPS server within SSIS using the FTPS API.
Connect to an SFTP server within SSIS by utilizing the SFTP API.
Source: Supports reading data from a file system through local, FTPS or SFTP connections.

Destination: Supports writing data to a file system using Upload, Move, or Delete write action. Supports FTPS, SFTP and local connections.
Source: A more robust SSIS Flat File Source component to make reading files easier.

Destination: A more robust SSIS Flat File Destination component to make writing to files easier and more flexible.

Task: An SSIS task component to transfer and perform basic file system tasks.
The SSIS Timer Task pauses package execution between Control Flow items.
Anonymize or mask sensitive data before moving it into another system by generating random sample data in the column based on a selected anonymization type.
A source component which generates random sample data for testing purposes.
Connection: Establish a connection with SSIS to an HTTP website, supports access to SOAP or REST based web services.

Transformation: Can be used to send a series of HTTP requests and process their response.

Task: Can be used to send an HTTP request and receive a response.
Source: Enables SSIS developers to retrieve data from virtually any SOAP based service endpoint.

Destination: Enables SSIS developers to write data to virtually any SOAP based serviced endpoint.

Task: An SSIS task component which enables developers to read/retrieve data from a web service.
Compress or decompress files or directories within the SSIS Control Flow using the ZIP archive file format.
Perform PGP encryption actions on a file in SSIS; it can be used to encrypt, decrypt, CreateSignature or VerifySignature.
Connection: Facilitates connection to a Google Analytics account through the Google Analytics Rest API.

Source: Facilitates retrieving Google Analytics data, supports custom segments, dimensions and metrics.

SSIS Integration Toolkit
Productivity + Connectivity
Over 125 of the most advanced SSIS components in the industry

Download my free copy


Application-Based Connectivity Enhancements for SSIS

Powerful SSIS components designed to address the specific integration requirements for some of the world's leading enterprise applications. At a minimum, each application contains a Connection Manager, a Source Component and a Destination Component, some products also contain an additional component to address unique integration requirements for the individual application. These connectivity solutions are available on their own or all together with the SSIS Productivity Pack in the Ultimate Edition.