Premium Data Flow Components are SSIS components which work to expand and enhance the features of native SSIS components.

Within SSIS Productivity Pack, we offer some advanced SSIS components which provide some significantly improved features comparing to the out-of-box counterpart components. Those components help you achieve more with less effort.

We currently have five premium SSIS data flow components available, including:

  • Premium ADO.NET Source
    • An advanced version of the standard ADO.NET Source component to support 7 types of data providers including Oracle and MySQL.
  • Premium ADO.NET Destination
    • An enhanced ADO.NET Destination component to support writing to 7 types of data providers through 4 write actions; Insert, Update, Delete, or Upsert.
  • Premium Derived Column
    • Supports all the functionality of the out-of-box component plus has a total of over 200 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 to be used 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 to create a simplified development experience without any limitations. The component can process three types of slowly changing dimensions: Fixed Attributes which are never supposed to change, Changing Attributes which can change but don't have a history, and Historical Attributes which can change, and a history of all previous values is kept. The component requires two inputs: A primary input with data that should be monitored for changes, and a secondary input with potentially changed data.
  • Excel Connection Manager
    • Connects to local Excel files and supports password encrypted files. This connection manager is needed in order to use the Premium Excel Source or the Premium Excel Destination.
  • Premium Excel Source
    • An enhanced Excel source, this premium components allows developers greater flexibility with the excel file set-up with support for specifying which row you want to start reading data from, how many rows you would like to retrieve and more.
  • Premium Excel Destination
    • An enhanced Excel destination component, this premium component gives developers great flexibility in how data should be written to the excel file such as writing new data, overwriting existing data, adding to the end, or writing to specific rows as well as many other additional features.

Youtube Video - Getting started with SSIS Productivity Pack - Premium Derived Column

Youtube Video - Getting started with SSIS Productivity Pack - Premium Lookup

Youtube Video - Getting started with SSIS Productivity Pack - Premium Slowly Changing Dimension

Youtube Video - Getting started with SSIS Productivity Pack - Premium ADO NET Components