Post reply

Help me: How to capture the execution results (execution time) ??

  • July 26, 2014 at 9:25 am

    #397121

    Hi Friends,

    I am just entering into the world of SSIS, I have to capture each of the execution time (please refer the attached screen shot), my package is having 5 tasks/ executables. kindly guide me how I could make it successfully.

    Note: in the attachment i have marked the start time and endtime of one particular task, like that i need to capture all the task information.

    kindly help me, I tried with system variables, (mapped two, but only one is being tracked and entered into the table.) but unable to capture it successfully.

    thanks in advance.

    -Prabhu

  • July 27, 2014 at 9:42 am

    #1732666

    Hi

    You can use event handlers and then in whatever event you want you can use script task to pass datetime.now value to a user variable

    Thanks

    Lokesh Sharma
    sql4all.org

  • July 27, 2014 at 9:23 pm

    #1732690

    Look at configuring logging for the package itself if you are just looking for start and end time of each task. As well if you are using SQL Server 2012 or higher, this type of information can be obtained through the SSIS catalog if you are using the project deployment method.

    Shawn Melton
    Twitter: @wsmelton
    Blog: wsmelton.github.com
    Github: wsmelton

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

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