DTS to SSIS ExecutionStatus Inactive

Hi ,

I have code in SQL Server 2000 (DTS). what is same code to inactive execution status in SSIS

If returnValue <> "" Then

DTSPackage.Steps("DTSStep_DTSDataPumpTask_2").ExecutionStatus = DTSStepExecStat_Inactive

Else

DTSPackage.Steps("DTSStep_DTSDataPumpTask_3").ExecutionStatus = DTSStepExecStat_Inactive

End If

Thanks,

Raja

You could try using either an expression on your precedent constraint in the control flow or a conditional split in the data flow.

|||

Hi Martin,

Thanks for your reply.

I declare global variable returnValue as Boolean default false and set Precedence Constraint property

EvalOP = ExpressionAndConstraintand Expression = @.returnValue == Trueit is working fine.

Thanks,

Raja

Raja