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

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

We currently have fourteen premium SSIS Data Flow Components available with two corresponding connection managers:

  • Premium ADO.NET Source
    • An advanced version of the standard ADO.NET Source component that supports 11 types of data providers, including Oracle and MySQL.
  • Premium ADO.NET Destination
    • An enhanced ADO.NET Destination component to support writing to 11 types of data providers through four write actions: Insert, Update, Delete, or Upsert.
  • Premium ADO.NET Command Task
    • A control flow component that can be used to run commands to a database instance directly at control flow level. It can execute queries and also get the output in any required manner.
  • Premium Aggregate
    • A data flow transformation component that can be used to perform an aggregate operation on the input columns and group them into a data set
  • Premium Conversion
    • An enhanced data conversion component to convert or make changes to the data type of input columns.
  • Premium Derived Column
    • Supports all the functionality of the out-of-box component with a total of over 294 functions, an advanced expression editor, advanced data type detection, and the ability to validate and test expressions with test values.
  • Premium Excel Connection Manager
    • Connects to local Excel files and supports password-encrypted files.
  • Premium Excel Source
    • An enhanced Excel source that supports both 32 and 64-bit runtimes. This premium component 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 that supports both 32 and 64-bit runtimes. 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.
  • 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.
  • OData Connection Manager
    • This SSIS connection manager is used to connect to an OData instance.
  • Premium OData Source
    • An SSIS data flow source component that can be used to read from OData endpoints.
  • Premium OData Destination
    • An SSIS data flow destination component that can be used to write to OData endpoints.
  • Premium PDF Source
    • An SSIS Source component that can be used to extract data from tables in PDF files.
  • Premium Recordset Source
    • An SSIS Source component that can be used to extract data from within record sets from object variables.
  • Premium Service Lookup
    • The Premium Service Lookup component provides lookup capabilities by searching records in a REST object through a REST connection.
  • Premium Slowly Changing Dimension
    • An enhancement on the SSIS out-of-box component to create a simplified development experience without any limitations. This 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.

Video Resources

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

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

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