A collection of premium SSIS components to enable greater developer productivity and increase the power of SSIS. With the SSIS Productivity Pack, developers can get their job done quicker using some of the most advanced ETL components in the industry.
Set up automatic SSIS job execution summary email notification with ease using the SMTP task
Keep sensitive data in production, anonymize data before bringing into UAT environments
Unleash the full power of SSIS expression utilizing the Premium Derived Column component
Throttle package execution using the easy-to-use Timer Task
Compress files with the powerful Compression Task
Read and write to virtually any SOAP based Web Service
A data flow transformation component which allows you to anonymize or mask your sensitive data.
Sample data generation in SSIS can be done easily using the Data Spawner component.
Diff Detector Component is an SSIS data flow pipeline component that can be used to compare fields from a primary and secondary input.
Duplicate Detector is an SSIS data flow pipeline component that can be used to compare rows within a data source and identify duplicate rows.
SSIS Compression Task allows you to compress or decompress .zip files in the Control Flow.
The PGP Task is an SSIS control flow task that can be used to perform encryption actions on a file.
The HTML Merge Component is a Data Flow Transformation component which can merge columns and variable data using a pre-defined HTML template.
The Text Merge Component is a Data Flow Transformation Component which can merge column and variable data using a pre-defined text template.
The Premium Derived Column supports all the functionality of the standard SSIS Derived Column, plus many more expressions, an advanced expression editor, in-place expression validation & testing, advanced data type detection, and more.
The premium ADO.NET Source Component that offers better metadata handling with support for many different data providers.
The premium ADO.NET Destination is an enhanced ADO.NET destination component which offers many features including the support of all write actions such as Insert, Update, Delete and also Upsert.
The Email Connection Manager is an SSIS connection manager component that can be used to establish connections to an Email server (IMAP, POP3 or Exchange Web Services).
The Email Source Component is used to receive emails from a server and output them to columns (IMAP, POP3 or Exchange Web Services).
The SMTP Connection Manager facilitates connections to an SMTP server.
The SMTP Destination Component is a Data Flow component which is used to send emails using data from upstream pipeline components.
The SMTP Task Component works at the Control Flow level for sending emails to predefined recipient(s).
The SSIS Timer Task pauses package execution between Control Flow items.
The HTTP Connection Manager makes it easy to connect to an HTTP website.
The HTTP Requester is an SSIS data flow pipeline component that can be used to send a series of HTTP requests and process their responses.
The HTTP Requester Task is an SSIS control flow task component that can be used to send an HTTP request and receive a response.
The Web Services Source Component can be used to read data from a SOAP service endpoint.
The SSIS Web Service Destination Component can be used to write data to virtually any SOAP-based application systems using its SOAP service endpoint.
The Web Service Task is an SSIS control flow component that can be used to read / retrieve data from a web service.
Technical Requirements: The SSIS Productivity Pack requires Microsoft SQL Server, we support Microsoft SQL Server 2016, 2014, 2012, 2008 R2, 2008, and 2005.