Hi all, I've a SSIS package which has many data flow tasks, Execute SQL Tasks, Execute Package Tasks etc. Package is running without issues. But if anyone of those tasks takes more time, I should get an alert email saying this task is taking more time. How this can be done? Can anyone help me on this? Regards, Ram

You can implimenting the logging in SSIS packages please check here http://msdn.microsoft.com/en-us/library/ms138020.aspx Cheers Ramhttp://uk.linkedin.com/in/ramjaddu