The components listed below are some of our unique SSIS Timing & Automation components that developers may use daily to enhance their productivity.
These Timing & Automation Components stand on their own to provide unique data scheduling and time-related features, unlike any other components 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.
- 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
