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
Retrieve emails from a POP3, IMAP, or Exchange Web Services server and output them to columns
Perform text or HTML content merge with SSIS columns/variables with an easy-to-use UI.
Bring data from JSON or XML documents into SSIS easily with extract components
Output column data into JSON or XML format with ease using merge components
Quickly an efficiently generate sample data for testing
Connect to FTPS or SFTP servers easily within SSIS
Perform lookups with any data input as the lookup source without limitation
Development for Slowly Changing Dimensions cannot be any easier
Easily connect to and integrate data with Azure Service Bus
Throttle package execution using the easy-to-use Timer Task
Identify and detect duplicates from upstream source system using many configurable duplicate matching algorithms
Compare data from two sources with the Diff Detector to find any differences between rows
Go beyond Insert - Update, Delete or Upsert to databases with Premium ADO.NET Destination
Compress files with the powerful Compression Task
Read and write to virtually any SOAP based 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.