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

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.