dbTalk Databases Forums  

script in jscript to execute or not the next task

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss script in jscript to execute or not the next task in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Miguel Canas
 
Posts: n/a

Default 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

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.