Hi,

Im having trouble de-activating a task (DTSStep_DTSDataPumpTask_1) if a
certain datasource has no data in it.
The error which i am getting is: Invalid Step Result Value.

Could anyway help?
Raj


This is the script i am executing:


Function Main()

Dim oFSO, File, oStep, oPkg, oDataPump

File = DTSGlobalVariables.Parent.Connections("D2RL
Copy").DataSource
Set oFSO = CreateObject("Scripting.FileSystemObject")
Set oPkg = DTSGlobalVariables.Parent

Set oStep = oPkg.Steps("DTSStep_DTSDataPumpTask_1")

If oFSO.FileExists(File) Then

msgbox "exists"

If oFSO.GetFile(File).Size > 0 Then

Main = DTSStepExecResult_Success
Else
msgbox "file is empty"

' Update the following task's precedence constraint
' - Execution status of inactive
'the precedence for both PBasis and Value is set to 0

msgbox(oStep.PrecedenceConstraints(1).PrecedenceBa sis)
msgbox(oStep.PrecedenceConstraints(1).Value)

oStep.PrecedenceConstraints(1).PrecedenceBasis = _
DTSStepPrecedenceBasis_ExecResult
oStep.PrecedenceConstraints(1).Value = _
DTSStepExecStat_Inactive

End If
Else

Main = DTSStepScriptResult_DontExecuteTask

End If

Set oFSO = Nothing

End Function

There are some examples here-

Workflow
(http://www.sqldts.com/?103)


--
Darren Green
http://www.sqldts.com
http://www.sqlis.com

"Raj" <bassi.raj (AT) gmail (DOT) com> wrote

"Raj" wrote:


If (parameter = desired_results) Then
Main = DTSTaskExecResult_Success
else
Main = DTSTaskExecResult_Failure
end if

set your workfloe arrows to something on failure and on another for success

So the way I would do this is I would check the row count in an ExecuteSQL
task and assign the value to a Global variable. I would then from that task
have an Active Script task that asked if the value of the variable was >
0. If it was not then I would do something similar to this article

http://www.sqldts.com/default.aspx?246

The subject says skip whereas the text suggests simply disabling. If you
actually want to skip tasks then have a look at this article

http://www.sqldts.com/default.aspx?214

Allan