The Data Warehousing components from the SSIS Productivity Pack are SSIS components that facilitate integration with Data Warehouses such as Snowflake.

The SSIS Productivity Pack currently supports integration with Amazon Redshift, Google BigQuery, PostgreSQL, Snowflake as well as support for the Premium Slowly Changing Dimension (PSCD) data flow pipeline component in SSIS.

The following are the SSIS Data Warehousing components available within the SSIS Productivity Pack and their help manuals:

Amazon Redshift Components

Google BigQuery Components

PostgreSQL Components

  • PostgreSQL Connection Manager
    • Facilitates connecting to PostgreSQL from within SSIS.
  • PostgreSQL Source Component
    • An SSIS data flow pipeline component that can be used to read / retrieve data from PostgreSQL instance databases.
  • PostgreSQL Destination Component
    • An SSIS data flow component used to write to a Destination table in a PostgreSQL instance.
  • PostgreSQL Command Task
    • A control flow component that can be used to run commands to PostgreSQL instance directly at control flow level. It can be used to execute queries, and also to get the output in a required manner.

Slowly Changing Dimensions Components:

  • Premium Slowly Changing Dimension Component
    • The Premium Slowly Changing Dimension Component is an SSIS data flow pipeline component that can be used to monitor changes in the value of dimension fields that change slowly. Slowly changing dimensions are dimensions with values that are relatively static and change infrequently and unpredictably. 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.

Snowflake Components:

  • Snowflake Connection Manager
    • Facilitates connecting to Snowflake from within SSIS.
  • Snowflake Source Component
    • An SSIS data flow component used to retrieve data from Snowflake. Includes the option to specify retrieval mode such as retrieving files and folder or only files or choosing whether sub items should be retrieved as well.
  • Snowflake Destination Component
    • An SSIS data flow component used to facilitate writing data to Snowflake. This component supports CreateFolder, Delete, and Upload actions when writing to Snowflake.
  • Snowflake Command Task
    • A control flow component that can be used to run commands to Snowflake directly at control flow level. It can be used to execute queries, and also to get the output in a required manner.

Video Resources

Youtube Video - Getting started with SSIS Productivity Pack - PostgreSQL

Youtube Video - Getting started with SSIS Productivity Pack - Snowflake

Youtube Video - Getting started with SSIS Productivity Pack - Amazon Redshift