Hi, Number of Pakcages are running in my server and I just want to know utilization details such as which package and which task of the package is running for more time, which one is taking much memory and all related details. I really appreciate if you guys give inputs on the appraoches for capturing those utilization details? Thanks in advance!!!

you need to put some custom logging in your SIS package to see the execution details or you can achieve the same through the built in SSIS logging through OnPreExecute and OnPostExecute event handler. and for memory consumption you need to monitor your packages through performance monitor tool.following are the peformance counters which you should monitor while your package is running: •Buffers in use •Flat buffers in use •Private buffers in use •Buffers spooled •Rows read •Rows written for custom logging see this article (http://consultingblogs.emc.com/jamiethomson/archive/2005/06/11/SSIS_3A00_-Custom-Logging-Using-Event-Handlers.aspx) for memory consumption see this article(http://blogs.msdn.com/b/sqlperf/archive/2007/05/01/something-about-ssis-performance-counters.aspx) Cheers, Zaim Raza.

I think its the same question as this one : http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/e0cb521f-85a4-4da7-8e02-8cad922641f1Happy to help! Thanks. Regards and good Wishes, Deepak. http://deepaksqlmsbusinessintelligence.blogspot.com/