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/