Tuesday, January 12, 2010

Conditional Split Equivalent in Control Flow SSIS

A good way to achieve Control Flow based on a Condition is by using a dummy script task and set the TaskResult property to success.

Public Class ScriptMain

Public Sub Main()
Dts.TaskResult = Dts.Results.Success
End Sub

End Class

You can then add precedence constraints on the Containers/Tasks to direct your control flow. For E.g., Double click on the connecting arrow and Add an Expression as a precedence constraint -

@[User::RowCount] == 0

No comments:

Post a Comment