OasisChurch
Technical User
- Mar 28, 2002
- 20
Hello:
I am calling a saved DTS package (com storage) and when I execute it manually or from a command prompt, it works fine. However, When I execute it from a batch file it hangs. Here's the kicker - it's intermitten. It works 20% of the time and does not work 80% of the time. I have re-installed SQLServer 2000 and included service pack 3. This is running on a Win2003 box w/ no other processes running.
Could it be a memory issue?
Any ideas? I have been working on this issue for two days.
Thanks in advance!!
-scotta
I am calling a saved DTS package (com storage) and when I execute it manually or from a command prompt, it works fine. However, When I execute it from a batch file it hangs. Here's the kicker - it's intermitten. It works 20% of the time and does not work 80% of the time. I have re-installed SQLServer 2000 and included service pack 3. This is running on a Win2003 box w/ no other processes running.
Could it be a memory issue?
Any ideas? I have been working on this issue for two days.
Thanks in advance!!
-scotta