dbTalk Databases Forums  

Execution was canceled by user

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


Discuss Execution was canceled by user in the microsoft.public.sqlserver.dts forum.



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

Default Execution was canceled by user - 09-16-2004 , 12:35 PM






I have a bunch of DTS packages that get executed by a single master DTS
package that I have scheduled to run as a job nightly. This has been running
just fine for about 1 year and now suddenly it is failing. When executing it
manually I receive a "Execution was canceled by user" message on a Transform
Data task within one of the detail packages. KB article 319058 hasn't helped
me get it running. The only thing that seems to work is if I change the
master DTS package to use DTSRun command inside a Execute Process Task rather
than a Execute Package Task.

I'd like to go back to being able to rely on the Execute Package Task. Any
ideas on what might have triggered this bug and how to get it fixed?

--
Thanks,
Brian

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.