Timing and Automation Components

Timing and Automation Components

Streamline your data processing with a variety of flexible SSIS components for seamless workflow management and automation. These stand-alone Timing and Automation Components provide unique data scheduling and time-related features, unlike any other components found in 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.
    
• Windows Command Task
  • A control flow component that can be used to run Windows and PowerShell commands directly at the control flow level.

Video Resources