Package start and end times

Question

Hi ,

I wanted to know if there is any system variable which is can use to access package execution start and end times. My requirement is that i need to store this in 2 relevant fields in a table in the database.

Thank you.

Abhi

Answer 1

Why don't you enable logging via the SSIS menu? You could configure SSIS to log events to a SQL Server.

That way, you will not only have the start and end time it will be much easier to locate any errors.

http://msdn.microsoft.com/en-us/library/ms139845.aspx

Answer 2

There's a variable system::Starttime and why don't you just use a getdate() function when you're saving to the DB