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 coloum Premium 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 225 functions, an advanced expression editor, advanced data type detection and the ability to validate and test expressions with test values.

ssis premium lookup Premium 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 dimension Premium 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 sources Diff 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 anonymization Data 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 detector Duplicate 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 extract JSON 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 merge JSON 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 extract XML 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 merge XML 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 merge HTML 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 merge Text 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 conversion Time 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.

There are many more components included within the SSIS Productivity Pack

Check Them All Out