February 1, 2012 at 3:11 am
Hi All,
I was able to run the Excel VBA macro successfully from SSIS 2008 using Active X Script task. But the challenging thing i am facing is, even if i stop the package my macro still runs once it is started as it takes to complete quite long time ~40min. So, is there any way even stop the macro as well?
Thanks in Adavance
February 1, 2012 at 10:29 am
Not from SSIS, once it's handed off the VBA command. You'll have to log into the machine and directly stop the process via Task Manager. Stopping the process should mean no further commands are handed over though.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
February 2, 2012 at 5:05 am
can you not kill all instances of Excel?
with something like
private void killExcel()
{
System.Diagnostics.Process[] PROC = System.Diagnostics.Process.GetProcessesByName("EXCEL");
foreach (System.Diagnostics.Process PK in PROC)
{
if (PK.MainWindowTitle.Length == 0)
{
PK.Kill();
}
}
}
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply