If I cancel a DTS run while it is running another package,
then I cannot run that package again from within any other
package. I keep getting the message "Execution was
cancelled by user."

When I launch the package directly , it runs fine.

Can anyone help? This is a big problem.

thank you

Hi Doug,

Thank you for using MSDN Newsgroup! It's my pleasure to assist you with your issue.

First of all, I would like to confirm my understanding of your issue.

From your description, I understand that you met with problem when you ran one package
from within another one, but you really could run it in a manual/direct way. Have I fully
understood you? If there is anything I misunderstood, please feel free to let me know.

However, I'm unsure of the detailed information about your packages and how they were
executed and what they performed. Please read the following article first to see if it's relevant
to your scenario:

319058 BUG: DTS Package Execution Is Canceled Unexpectedly in a Visual Basic
http://support.microsoft.com/?id=319058

Based on my experience, if you use "Execute Package Tasks", I'd like to recommend you
change to use "Execute Process Tasks" instead, and use dtsrun.exe to invoke the package.
Another consideration is to use the SQL Server agent scheduler or use the Windows
Scheduler.

If all above don't make sense on your issue, please describe the structure of the DTS
packages in detail and specify how to reproduce this issue. In this way, I can perform a further
testing on my side to address the problem and see if there will be a workaround or solution to
this problem.

If there is anything more I can do to assist you, please feel free to post it in the group

Best regards,

Billy Yao
Microsoft Online Support
----------------------------------------------------
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.

Thank you very much for your help. I am sure that running the package
from a .bat file will work fine. It is a great solution.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!