A premium collection of SSIS component add-ons that developers will use every day to increase their SSIS productivity.
Over 300 premium and unique SSIS components to facilitate rapid ETL development without any custom scripting.
Premium SSIS components expand on native SSIS components to offer new features with improved performance and greater ease of use.
The SSIS Productivity Pack saves time and offers significantly greater potentials when implementing solutions using SSIS.
Built utilizing Microsoft SQL Server Integration Services (SSIS), a performant and flexible ETL platform, allowing your team to take advantage of the technologies and skills they already have.
The SSIS Productivity Pack is a gold mine of features that allows for powerful data transformation in one easy-to-use component.
EDI Source and Destination
Extract data from EDI documents to use in downstream pipeline and easily write to EDI files.
Support for over 100 APIs in the REST framework
Auth0, Bill.com, ClickUp, Discord, Drift, Expensify, Google Forms, Jotform, Mailjet, Okta, PowerBI, PrestaShop, ShipStation, and more
Testimonials
"The Premium Derived Column component in the SSIS Productivity Pack was a gold mine of features that allowed for powerful data transformation in one easy to use component."
Winson Group"Getting the SSIS Productivity Pack enabled us to build connections to numerous API's in a timely fashion."
Weiss Research, Inc.Testimonials
"The Premium Derived Column component in the SSIS Productivity Pack was a gold mine of features that allowed for powerful data transformation in one easy to use component."
"Getting the SSIS Productivity Pack enabled us to build connections to numerous API's in a timely fashion."
Bring data from JSON or XML documents into SSIS easily with source or extract components.
Keep sensitive data in production, anonymize data before bringing into UAT environments.
Work with Excel data in both 32 and 64-bit runtimes.
Unleash the full power of SSIS expression utilizing the Premium Derived Column component.
Quickly and efficiently generate sample data for testing.
Perform address verification in a batch fashion.
Development for Slowly Changing Dimensions cannot be any easier.
Go beyond Insert - Update, Delete or Upsert to databases with Premium ADO.NET Destination.
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.
Work with NoSQL data as if it were column data.
Perform lookups with any data input as the lookup source without limitation.
Read or write to an OData instance endpoints without effort.
Encrypt and decrypt files from within the SSIS control flow.
Easily connect and integrate with various message queue services without writing a line of code.
Quickly retrieve Google Ads and Analytics data.
Connect to FTPS or SFTP servers easily within SSIS.
Throttle package execution using the easy-to-use Timer Task.
Set up automatic SSIS job execution summary email notification with ease using the SMTP task.
Compress files with the powerful Compression Task.
Retrieve emails from a POP3, IMAP, or Exchange server and output them to columns.
Perform text or HTML content merge with SSIS columns/variables with an easy-to-use UI.
Extract data from EDI documents to use in downstream pipeline and easily write to EDI files.
Easily convert a date column from one timezone to another.
Connectors
Our solution is built utilizing Microsoft SQL Server Integration Services (SSIS), allowing your team to take advantage of the technologies and skills they already have. The drag-and-drop user interface makes it easy to set up powerful integrations within a matter of minutes.
Technical Requirements: The SSIS Productivity Pack requires SQL Server Integration Services, we support deployments to Azure-SSIS Integration Runtime (ADFv2) or Microsoft SQL Server 2022, 2019, 2017, 2016, 2014, and 2012.
