Home Forums SQL Server 2005 SQL Server 2005 Integration Services How do I capture the start time of a package and how long in munutes it took to complete? RE: How do I capture the start time of a package and how long in munutes it took to complete?

  • February 20, 2015 at 1:43 am

    #1778877

    you can schedule your package with the SQL job and then check the all information from (msdb..dbo.sysjobhistory) table.

    OR

    you can use the system variable ("StartTime") and end time with the help of getdate() function.

    ____________________________________________________________

    AP