conditional execution of ssis package
Hi all,
Is there a way to check the source systems level of utilization before a package starts execution? If the source systems OS is Windows 08 or 08r2 I utilized WMI before but this time the OS is V5R4. The idea is to make sure that there are sufficient resources
(CPU, memory, no table locks etc.) available. I have situation where my packages just hangs and never progresses.
Hints appreciated
Thx
Ludwig
May 19th, 2012 7:48pm
Hi Ludwig,
You can create a SQL Agent Job and run the SSIS package according to your condition. Follow the link to see how to get CPU utilization by T-SQL
http://social.msdn.microsoft.com/Forums/en/sqldatabaseengine/thread/38f34421-60b8-4bf4-b779-56e2f1d70cc0
Free Windows Admin Tool Kit Click here and download it now
May 20th, 2012 3:21am
you can create a script for cpu usage and memory available and return into one bit variable 1 or 0 and condition based on this variable in conditional split.
this might helps you.
Regards, nishantcomp2512 Please mark posts as answered where appropriate
May 20th, 2012 2:13pm
use WMI EVENT WATCHER TASK
http://msdn.microsoft.com/en-us/library/ms141130.aspx
in this task you can write queries to check if cpu usage is lower 30% then do next task and other events like that.
for writing appropriate WMI queries (WQL), I recommend use this small helpful application:
http://www.microsoft.com/en-us/download/details.aspx?id=8572http://www.rad.pasfu.com
Free Windows Admin Tool Kit Click here and download it now
May 20th, 2012 5:00pm