Post reply

SSIS - How do I log timestamp when each individual task completed ?

  • January 4, 2016 at 9:58 am

    #306749

    Please see the attached pic first.

    I like to add an event handler and in that I could setup a SQL task to write to a table when a "SQL TASK" or "DATA FLOW TASK" got completed. I mean the timestamp.

    Ideal place would be to have an event_handle for this ?

    Can anyone tall me what should I pick under "Executable:" dropdown and "Event Handler" drop down ?

    There is one evern handler by the name 'OnTask Failed" but I don't see any that says "On Task Completed"

    Please help....

    txtPost_CommentEmoticon(':-)');

  • January 4, 2016 at 10:13 am

    #1849266

    mw112009 (1/4/2016)

    Please see the attached pic first.

    I like to add an event handler and in that I could setup a SQL task to write to a table when a "SQL TASK" or "DATA FLOW TASK" got completed. I mean the timestamp.

    Ideal place would be to have an event_handle for this ?

    Can anyone tall me what should I pick under "Executable:" dropdown and "Event Handler" drop down ?

    There is one evern handler by the name 'OnTask Failed" but I don't see any that says "On Task Completed"

    Please help....

    txtPost_CommentEmoticon(':-)');

    OnPostExecute might be the closest you'll get.

    Or rely on native logging and read directly from SSISDB.

    Or add Execute SQL tasks before and after to do the logging in the control flow.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • January 4, 2016 at 10:47 am

    #1849283

    OnPostExecute works well....

    This is the best answer.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply