Time Delay Task
Time Delay Task suspends the current thread for given amount of time (measured in Seconds).
The Time Delay Task only has a single input parameter – which is the amount of time that the thread should be suspended for. This value is measured in Seconds and is by default set to 1.
Configuring Time Delay Task
Similarly to adding other SQL Server Integration Services (SSIS) tasks, the Time Delay Task shown in Figure 1 can be added into the Control Flow pane in the following manner;
- Drag-and-drop the Time Delay Task into the Control Flow, or
- Double clicking the Time Delay Task
By default the Time Delay Task will throw validation errors shown in Figure 2.
To resolve the validation errors, we need to configure the Time Delay Task by using its editor (Time Delay Task Editor) shown in Figure 3.
We can set values of Number of Seconds in two ways:
Set Absolute Values
Either you can use the default value of 1 or type in another numerical value, as shown in Figures 4.
Dynamically Set Values using Expressions
Expressions reads data from package variables at runtime. To configure expressions, click the Ex button. This will open up a Choose Variable dialog box. You can then select the variable you want to use and click the OK button.
Note: Only variables defined as numeric (i.e. Int32, Int64 etc.) will be retrieved and available and for selection.
Once you have clicked the OK button, you will be redirected back to the Time Delay Task Editor with Number of Seconds textbox set to the selected variable name as shown in Figure 6.
Executing Time Delay Task
Similarly to executing other SSIS tasks, the simplest way of executing Time Delay Task is to right-click your mouse button, navigate to and click Execute Task option as shown in Figure 7.
If the configuration is done correctly, the Time Delay Task execution should be successful as shown in Figure 8.
Additional Informational Events
As the Time Delay Task is being executed, it is important to take note of an information event that will appear in the Execution Results tab in the designer. As indicated in Figure 9, this informational event basically describe the parameter value that are being used in during task execution. This information could be useful during troubleshooting, especially in cases where Expressions are used to set parameter values.