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.

The SSIS Productivity Pack

  • A premium pack of the most advanced ETL components to make SSIS more powerful.
  • Enables developers to accomplish more in SSIS in a much more productive fashion.
  • Eliminates the needs of writing custom scripts for some commonly-encountered complex requirements in SSIS.
  • Premium SSIS components expand on native SSIS components to offer new features with improved performance and greater ease of use.
  • The Productivity Pack saves time and offers significantly greater potentials when implementing solutions using SSIS.
  • The pack currently includes 3 Connection Managers, 14 Data Flow Components and 6 Task Components, with many more to come.
  • Available on its own or as part of a package within the SSIS Integration Toolkit - Ultimate Edition, which includes the Premium File Pack for working with FTPS, SFTP and local or cloud files.
SSIS Productivity Pack

Product Highlights

  • Premium Derived Column offers nearly 200 functions and an advanced expression editor among many additional features and performance enhancements.
  • Web Service components connect to virtually any SOAP-based service endpoints to read or write data.
  • Sending emails in an individual or batched fashion can be done easily in SSIS using the SMTP components including support for email attachments.
  • Retrieve emails from a POP3, IMAP, or Exchange Web Services server and output them to columns.
  • Sample data generation cannot be any easier than the Data Spawner component.
  • Compare data from two sources with the Diff Detector to find any differences between rows.
  • Use Duplicate Detector component to identify and detect duplicates from upstream source system using many configurable duplicate matching algorithms.
  • Write records to a database by using Insert, Update, Upsert, or Delete actions over an ADO.NET Connection.
  • Use Premium ADO.NET Source component to read data from ADO.NET connections with a much more robust metadata handling.
  • Protect your sensitive data using the Data Anonymizer component before sending or moving the data to a different environment.
  • Perform text or HTML content merge with SSIS columns/variables with an easy-to-use UI.
  • Compress or decompress .zip files within SSIS.
  • Encrypt or decrypt files with PGP encryption.
  • Send a single or series of HTTP requests.
  • Set tasks within your SSIS package to run on their own timers.

SSIS Data Anonymizer

A data flow transformation component which allows you to anonymize or mask your sensitive data.

SSIS Data Spawner

Sample data generation in SSIS can be done easily using the Data Spawner component.

SSIS Diff Detector

Diff Detector Component is an SSIS data flow pipeline component that can be used to compare fields from a primary and secondary input.

SSIS Duplicate Detector

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

SSIS Compression Task allows you to compress or decompress .zip files in the Control Flow.

SSIS PHP Encryption

The PGP Task is an SSIS control flow task that can be used to perform encryption actions on a file.

SSIS HTML Merger

The HTML Merge Component is a Data Flow Transformation component which can merge columns and variable data using a pre-defined HTML template.

TextMerge

The Text Merge Component is a Data Flow Transformation Component which can merge column and variable data using a pre-defined text template.

SSIS Premium Derived Column

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.

SSIS Premium ADO.NET Source

The premium ADO.NET Source Component that offers better metadata handling with support for many different data providers.

SSIS Premium ADO.NET Destination

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.

SSIS Email Connection Manager

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).

SSIS Email Source Component

The Email Source Component is used to receive emails from a server and output them to columns (IMAP, POP3 or Exchange Web Services).

SSIS SMTP Connection Manager

The SMTP Connection Manager facilitates connections to an SMTP server.

SSIS SMTP Destination Component

The SMTP Destination Component is a Data Flow component which is used to send emails using data from upstream pipeline components.

SSIS SMTP Task Component

The SMTP Task Component works at the Control Flow level for sending emails to predefined recipient(s).

SSIS Timer Task Component

The SSIS Timer Task pauses package execution between Control Flow items.

SSIS HTTP Connection Manager

The HTTP Connection Manager makes it easy to connect to an HTTP website.

SSIS HTTP Requester

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.

SSIS HTTP Requester Task

The HTTP Requester Task is an SSIS control flow task component that can be used to send an HTTP request and receive a response.

SSIS Web Service Source Component

The Web Services Source Component can be used to read data from a SOAP service endpoint.

SSIS Web Service Destination Component

The SSIS Web Service Destination Component can be used to write data to virtually any SOAP-based application systems using its SOAP service endpoint.

SSIS Web Service Task Component

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.