Event handlers in SSIS are used to handle events. The events at SSIS level could be an error, a warning, information, a pre/post execution of a particular task, a variable value changes etc. SSIS provides flexibility to trap the events raised by executables at run time and do the processing as required by the user.
Event handlers tab is the place were the event handlers are defined.
To see the Events related to a specific control flow task, you can switch to Event Handler tab and select the particular Control flow task.
To demonstrate an example I selected the Data Flow Task, the events related with DFT were shown in the Event handler combo box.
We will see an example where the Data Flow Task Start Time and End Time can be captured at the Event Handler tab.
We can place a script task onpreExecute and onPostExecute events to show the Start and End Time of the DFT package.
MessageBox.Show("Package Start Time:" + DateTime.Now.ToString());
Inside the Script Task we are showing the date and time only:
MessageBox.Show("Package End Time:" + DateTime.Now.ToString());
Once we run the package we will get the message box which shows the start time and end time of DFT (Data flow task)
I hope you like the post.
For more information on Event Handlers you can visit this URL: http://msdn.microsoft.com/en-us/library/ms140223.aspx
