Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kissa49
Starting Member
10 Posts |
 Posted - 2009-02-19 : 10:56:11
|
| ... SECTION_NAME = 'Refresh' AND KEY_NAME = 'NextDataFileGroup'" Recordset.Open strSQL, Conn Do While NOT Recordset.EOF strFolderName = Recordset("KEY_NAME_VALUE") Recordset.MoveNext Loop Recordset.Close Set Recordset=Nothing Conn.Close Set Conn=Nothing If cInt(strFolderName) < 998 Then Main = DTSTaskExecResult_Success End IfEnd Function-- 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!!! |
|
|
|
|
|
"The task reported failure on execution"