-- strFolderName successfully retrieves a number from a field in a table. That field is a varchar field. The data is always a number and I need to return "SUCCESS" if the number is lower than 998 or "FAILURE" is that number is not.
I have this code in an Active Script Task in a DTS package. The task runs successfully and since at this point the number IS under 998 failure 'precedence' is not called. The success 'precedence' is called but fails with the "The task reported failure on execution" error.
Can anyone help me out with this please? I don't understand what this error means since the task does run successfully. Or is there an error in my code?
THANK YOU VERY MUCH IN ADVANCE FOR YOUR HELP!!!
SECTION_NAME = 'Refresh' AND KEY_NAME = 'NextDataFileGroup'"
Recordset.Open strSQL, Conn
Do While NOT Recordset.EOF
strFolderName = Recordset("KEY_NAME_VALUE")
If cInt(strFolderName) < 998 Then
Main = DTSTaskExecResult_Success