Hi All, If I create one ssis package, for suppose that package duration is 20 min some performance issue after 30 min also if the package will execute how to send alert message like this…30 min over. But still the package is execute please check it like this…how to implement this task in ssis? Thanks CMK..

I 'd say things to consider is how do you know if the package with 300K records today runs under 20 min and if tomorrow you get 2M it must be on time? You will most probably benchmark your most lengthly task or several of them in the package. Also typically if there are performance issues to send an alert, alas - there is no more resources. I would monitor a package from the outside, otherwise the package needs to break for a self-check. So it basically boils to the health monitoring using the performance counters (e.g. for the Data Flow Engine), info on this is here: http://msdn.microsoft.com/en-us/library/ms137622(v=SQL.90).aspxArthur My Blog