The components listed below are some of our unique SSIS Timing & Automation components which developer's may use every day to enhance their productivity.

These Timing & Automation Components stand on their own as providing unique data scheduling and time-related features not quite like any other components found within the SSIS Productivity Pack.

  • Azure Functions Connection Manager
    • A connection manager can be used to specify the connection information required, which can be used in Azure Functions Source and Destination component to trigger an Azure function.
  • Azure Functions Source
    • Used to execute Azure Functions and retrieve the response from the functions.
  • Azure Functions Destination
    • Used to execute Azure Functions using HTTP triggers.
  • Azure Functions Task
    • A control flow component that can be used to execute Azure Functions using HTTP triggers.
  • SSH Task
    • A connection manager can be used to create an SSH Connection.
  • Time Zone Conversion
    • An SSIS data flow component which can be used to convert a date column from one timezone to another.
  • Timer Task
    • An SSIS task component used to pause execution of a package with 3 available pause modes: Fixed Time, Wait Until, Wait Until Variable.

Youtube Video - Getting started with SSIS Productivity Pack - Timer Task

Youtube Video - Getting started with SSIS Productivity Pack - Time Zone Conversion