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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics