I have set up a small active X script in a DTS package. I've used the filesystemobject to copy any files which have been created today into another folder.
The script uses an IF command, if I leave the IF out the DTS package runs fine if I put it back in I get an Invalid task Result Value error. The script runs fine in VB.
Am I using the DTS Package incorrectly, the reason I wanted to put this into a DTS package is because the script then uses the copied files in a transformation.
Does anyone know what an Invalid Task result Value is?
Thanks
The script uses an IF command, if I leave the IF out the DTS package runs fine if I put it back in I get an Invalid task Result Value error. The script runs fine in VB.
Am I using the DTS Package incorrectly, the reason I wanted to put this into a DTS package is because the script then uses the copied files in a transformation.
Does anyone know what an Invalid Task result Value is?
Thanks