dbTalk Databases Forums  

Inconsistencies in running a DTS

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Inconsistencies in running a DTS in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Peter Newman
 
Posts: n/a

Default 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



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.