script in jscript to execute or not the next task -
02-05-2010
, 05:22 AM
Hello,
I'm a newbie in DTS's and Integration Services, but I need to migrate a DTS
to Integration Service but it's failing when i'm migrating the activex task
(in JScript).
I have the code below:
function Main()
{
if(DTS.Variables("APAGADOS").Value !=0)
return (DTSStepScriptResult_ExecuteTask);
else
return(DTSStepScriptResult_DontExecuteTask);
}
The previous step is a SQL Task who make a select to check if there are
results in a table then i move to the next task, and if the table is empty
then he don't execute the next task and finishes.
I create already a global variable to retrieve the count of rows of the
table.
Can anyone help me?
I hope so.
Thank you
url:http://www.ureader.com/gp/1146-1.aspx |