SSIS SQL 2005 capture starttime and endtime of a package?

Hi,
I run a bunch of packages and would like to create an audit table where i could log the start time and end time of every package i run. I notice there is the variable starttime but i do not know how to insert it in my sql..
Thanks for your help

2009-08-04T02:34:16Z

I would like to use the system variable not getdate()...

Daniel B2009-08-03T17:55:05Z

You could do this by putting a step at the start and end of the package with a statement like this:

insert into log ([Event],EventTime) values ('Package Start',getdate())

I have an SSIS package that I mantain that does this between each step in the package so I get a detailed log of how long things take to run.

00

Related Questions

How do you execute an SSIS package from SQL 2005 Management Studio?what is a package in SSIS (SQL Server Integrated Services 2005)?SQL Server 2005 SSIS capabilities?SSIS SQL Server 2005?Are you 'the total package'?

Trending Questions

why does my little sister make me download all of these python packages?5 answersWhat are the applications of Python?7 answerscreate a program every sum that shows the sum of 1 to n for every n from 1 to 50?4 answersWhat is the way to access the deep web?5 answersA question for programmers. Is it too late to start programming at age 35, but to get a job not just for fun. ?7 answers