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 nearly 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.

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

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