Post reply

SSIS Logging - capture start end time for STEPS only

  • May 2, 2007 at 7:44 am

    #178264

    SSIS Logging - I am currently logging my SSIS pkg execution to sysdtslog90 table. 

    -- Selecting "OnError" captures start/end time of entire pkg but NO detail. 

    -- Selecting "OnError", "OnExecStatusChanged" captures start/end time of entire pkg but NO detail.  

    -- Selecting "OnError", "OnExecStatusChanged", "OnInformation"  captures start/end time of entire pkg, individual steps, and LOTS OF EXTRANEOUS information.

    How can I capture JUST the start / end time for each individual "step" without all the extraneous detail.

    BT

  • May 2, 2007 at 8:11 am

    #703811

    Based on a few tests, I narrowed the SSIS logging events to limit the extraneous info being captured.  Here are the Logging Events I selected to reduce the extraneous info:

    OnError

    OnExecStatusChanged

    OnPostExecute

    OnPreExecute

    OnTaskFailed

     

    BT

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

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