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.
Read about these powerful SSIS transformation components below or get started now with a free trial.
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.
Includes over 275 functions, an advanced expression editor, advanced data type detection and the ability to validate and test expressions with test values.
Premium Lookup
Combines the functionality of the out-of-box Lookup and Fuzzy Lookup components into one simplified, easy to use component.
The Premium Lookup component allows for any data input as the lookup source and includes several additional matching options without any deployment limitations.
Premium Slowly Changing Dimension
An enhancement on the SSIS out-of-box component which creates an extremely easy development process without limitations.
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.
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).
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.
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.
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.
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.
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.
JSON Extract
A transformation component which extracts data from JSON documents and transforms the data into column data to use in downstream components.
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.
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.
Supports multiple inputs used to define the JSON hierarchical structure by selecting parent and child fields.
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.
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.
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.
Supports multiple inputs used to define the XML hierarchical structure by selecting parent and child fields.
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.
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.
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.
Premium 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.
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.
Premium ADO.NET
The Premium ADO.NET Source and Destination components offer expanded functionality to the out-of-box SSIS ADO.NET components.
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.
Premium OData
The Premium OData components are SSIS components that can be used to read or write to an OData instance.
With the Premium OData Destination component, developers can select between the following actions: <Create>, <Delete>, <Link>, <Unlink>, <Update>, and, Bound actions.
Premium Aggregate
With Premium Aggregate component, developers gain advanced SSIS functionality not found in the out-of-the-box version of the software.
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.
Premium PDF Source
The Premium PDF Source component is an SSIS Source component that can be used to extract data from tables in PDF files.
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.
Premium 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.
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.
Premium 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.
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