Package execution time

Package execution time

Post by m » Sun, 13 Apr 2003 01:24:06



Whate is the best way to determine the execution time of a
package? Ideally the time to complete would be included in
the e-mail at the end of the package that indicates it is
complete.

thanks

 
 
 

Package execution time

Post by Allan Mitchel » Tue, 15 Apr 2003 15:30:02


Hello, m!

Each step has an ExecutionTime property (seconds) so you could loop through
these and sum them.

--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

: Whate is the best way to determine the execution time of a
: package? Ideally the time to complete would be included in
: the e-mail at the end of the package that indicates it is
: complete.

: thanks
      ---  Microsoft CDO for Windows 2000