• I remembered how to do it. That was tough. 🙂

    Public Sub Main()

    Dim BasisControlRowCount As Integer = 0

    BasisControlRowCount = Dts.Variables("v_BasisControlRowCount").Value

    ' MsgBox(BasisControlRowCount)

    If BasisControlRowCount > 0 Then

    Dts.TaskResult = ScriptResults.Success

    Else

    Dts.TaskResult = ScriptResults.Failure

    End If

    End Sub

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/