Inconsistencies in running a DTS -
02-18-2004
, 02:56 AM
Im running a DTS that
1. Checks to see if a file exists in a director
2. Reads the fil
3. Imports the fil
4. Deletes the fil
5. Resets all the clobal varaibles and goes back to step 1
step 1 checks to see if a Global varaible IsRunning is true, if it is it drops out as the DTS is already running. If Not running it then executes step 2 etc. Using the same file.. for testing. I can run the DTS and it executes step 1 then stops. i then have to reset the Isrunning Global Variable and run it again.. It then runs fine. How can i debug this to find out why it is so inconsistant.. One minute it will run the next it wont.. i have checked to ensure the Isrunning Global Varaible is set to false, and the file is the same file each time. I do a file count in step 1.. each time regardless if it proceed to step 2 or not it returns a file count of 1 so IT should proceed to step 2, the file count is done ONLY if the Isrunning is set to false. The DTS is not returning any errors or any logical reason i can see as to why it is so inconsistant. I have checked the log and that looks fine.. no reasons there either
Can any one offer any advice |