The SSIS data flow transformation components found within the SSIS Productivity Pack enable developers to perform advanced data transformations without having to write a single line of code.

These unique, powerful, and easy to use components enable rapid data transformation that allow developers to accomplish more than ever before using SSIS.

These advanced transformations include premium SSIS components that build upon native SSIS components to enhance the functionality and offer solutions to more complex situations.

The SSIS Productivity Pack also offers components not found anywhere else to perform powerful complex SSIS transformations easily without needing any custom code.

SSIS advanced transformations

Read about these powerful SSIS transformation components below or get started now with a free trial.

premium derived columnPremium Derived Column

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.

SSIS Premium Derived Column

Includes over 275 functions, an advanced expression editor, advanced data type detection and the ability to validate and test expressions with test values.

ssis premium lookupPremium Lookup

Combines the functionality of the out-of-box Lookup and Fuzzy Lookup components into one simplified, easy to use component.

SSIS Premium Lookup

The Premium Lookup component allows for any data input as the lookup source and includes several additional matching options without any deployment limitations.

ssis slowly changing dimensionPremium Slowly Changing Dimension

An enhancement on the SSIS out-of-box component which creates an extremely easy development process without limitations.

SSIS Premium SCD

The component can process three types of slowly changing dimensions: Fixed Attributes, Changing Attributes and Historical Attributes and supports writing directly to an ADO.NET connection or any other output.

ssis compare two sourcesDiff Detector

Compares the fields from two sources to determine if rows are changed, unchanged, delete or added based on user selected business key(s).

SSIS Difference Finder

Offers several common matching types to handle unique matching requirements with a similarity threshold setting as well as options to ignore case and white spaces.

ssis data anonymizationData Anonymizer

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.

SSIS anonymize data

The component will generate relevant data based on user selection. For example FirstName anonymization type will generate First Names. The Number Anonymization Type includes parameter settings including min & max vales and decimal settings. There is also the ability to create a custom Anonymization Type.

ssis duplicate detectorDuplicate Detector

Compares rows within a data source to identify duplicate rows based on various match types. The Duplicate Rows output contains additional fields for further processing.

SSIS find duplicates

Advanced Match types (First Name Match, Phone Number Match, Street Address Match, US Zip Code Match, Company Name Match) allows developers to find duplicates even when various abbreviations, nicknames or formatting is used.

ssis json extractJSON Extract

A transformation component which extracts data from JSON documents and transforms the data into column data to use in downstream components.

SSIS JSON extract

Easily configure outputs by importing an example JSON or manually add/remove nodes to ready the component to extract data from JSON documents from the Input. JSON files can be retrieved locally or from various sources including SFTP, FTPS, OneDrive or Dropbox.

ssis json mergeJSON 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.

SSIS JSON merge

Supports multiple inputs used to define the JSON hierarchical structure by selecting parent and child fields.

ssis xml extractXML Extract

An SSIS transformation component that supports extracting column data from XML documents and transforms the data into column data to use in the downstream pipeline.

SSIS xml extract

Supports importing example XML document or an XSD schema with manual refinement to generate the expected hierarchy. XML files can be retrieved locally or from various sources including SFTP, FTPS, OneDrive or Dropbox.

ssis xml mergeXML 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.

SSIS XML merge

Supports multiple inputs used to define the XML hierarchical structure by selecting parent and child fields.

ssis html mergeHTML Merge

Merge column and variable data into an HTML template through a WYSIWYG or source editor.

SSIS html merge

Supports the ability to drag and drop columns or variables into the editor to construct the template. Developers have the option to set test values and render the HTML in preview mode.

ssis text mergeText Merge

Merge column and variable data into a text template with support for Headers & Footers.

SSIS text merge

Supports the ability to drag and drop columns or variables into the editor to construct the template. Developers have the option to set test values and preview an example of the merge.

ssis time zone conversionTime Zone Conversion

An SSIS transformation component for converting a date column from one timezone to another.

SSIS time zone conversion

Option to replace the current date value to the adjusted time zone date or output the date value to a new column.

ssis premium service lookup componentPremium Service Lookup Component

An SSIS transformation component that can be used to search for rows in a lookup object based on fields from rows in a primary input.

SSIS Premium Service Lookup component

Perform lookup against data sources by connecting to them from within the component. These advanced SSIS functions are available through a simple-to-use user interface that is flexible without compromising performance.

ssis Premium ADO.NETPremium ADO.NET

The Premium ADO.NET Source and Destination components offer expanded functionality to the out-of-box SSIS ADO.NET components.

SSIS Premium ADO.NET

With the advanced options and functionality, our Premium ADO.NET components become a developer's go-to solution when reading or writing to virtually any database.

ssis Premium ODataPremium OData

The Premium OData components are SSIS components that can be used to read or write to an OData instance.

SSIS Premium OData

With the Premium OData Destination component, developers can select between the following actions: <Create>, <Delete>, <Link>, <Unlink>, <Update>, and, Bound actions.

ssis Premium AggregatePremium Aggregate

With Premium Aggregate component, developers gain advanced SSIS functionality not found in the out-of-the-box version of the software.

SSIS Premium Aggregate

The Premium Aggregate component is a data flow transformation component that can be used to perform an aggregate operation on the input columns and group them to a dataset.

ssis Premium PDF SourcePremium PDF Source

The Premium PDF Source component is an SSIS Source component that can be used to extract data from tables in PDF files.

SSIS Premium PDF Source

With the Premium PDF Source component, developers can work with tables in PDF files including the ability to combine tables across pages, skip empty rows and deal with misaligned cells. These advanced SSIS functions are available through a simple-to-use user interface that is flexible without compromising performance.

ssis Premium ExcelPremium Excel

The Premium Excel components can create a new Excel file/sheet without code and allows for reading/writing from/to Excel files stored in: FTPS, SFTP, Amazon S3, Azure Blob Storage, Box, Dropbox, Microsoft OneDrive, and SharePoint.

SSIS Premium Excel

The Premium Excel components support working with both 32-bit and 64-bit runtimes as well as offering greater features and flexibility, and do not require Microsoft Office or any additional drivers to be installed.

ssis Premium ConversionPremium Conversion

The Premium Conversion component is an SSIS data flow transformation component that can be used to convert or make changes to the data type of input columns.

ssis Premium Conversion

With Premium Conversion component, developers gain advanced SSIS functionality not found in the out-of-the-box version of the software.

There are many more components included within the SSIS Productivity Pack

Check Them All Out