Help > Tasks > Timer Task >
SSIS Timer Task
PreviousNext

Timer Task can be used to add absolute or relative delay (upto days, hours, minutes or seconds) during your execution anywhere in the package.

Download SSIS PowerPack

Content

Step-By-Step

In this section you will learn how to pause execution of your package by adding specified delay time. in few clicks.
  1. From the SSIS toolbox drag ZS Timer Task on the designer surface.
    configure-ssis-timer-task
  2. Double click on the task to configure it.
  3. On the setting UI select [Wait for Relative time (this is by default selected)] and then enter desired seconds to wait.
    configure-ssis-timer-task
  4. Click OK to save UI settings.
  5. Execute the package and you will see once Timer Task starts executing it will wait for specified time you enter on the setting UI.
    configure-ssis-timer-task

Properties

Property Name Description
Mode This option determines mode of operation

Available Options

  • Relative (default) : Wait for exact time specified in the form of days-hours-minutes-second. Wait time is calculated from the start time of Timer Task.

  • Absolute : Wait until specified date/time is reached

TimerSeconds Seconds to wait (Not applicable if Wait Mode is Absolute)
TimerMinutes Minutes to wait (Not applicable if Wait Mode is Absolute)
TimerHours Hours to wait (Not applicable if Wait Mode is Absolute)
TimerDays Days to wait (Not applicable if Wait Mode is Absolute)
TimerDateTime Exact datetime until timer task should wait. This option is only applicable if you selected Absolute Mode and ReadDateTimeFromVariable is False
ReadDateTimeFromVariable Specifies how to read Absolute DateTime value. If this is False then it will read value from TimerDateTime property else it will read from variable specified by TimerDateTimeVariable property
TimerDateTimeVariable Variable name which holds exact datetime until timer task should wait. This option is only applicable if you selected Absolute Mode and ReadDateTimeFromVariable is True
LoggingMode Determines logging detail level. Available options are Normal, Medium, Detailed, Debugging

Remarks

Settings UI

ui-timer-task-settings

FAQ

References


Copyrights reserved. ZappySys LLC.