Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Trending News

Promoted
Philippe
Philippe asked in Computers & InternetProgramming & Design · 1 decade ago

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

Update:

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

1 Answer

Relevance
  • Daniel B
    Lv 7
    1 decade ago

    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.

Still have questions? Get your answers by asking now.