dbTalk Databases Forums  

Unexpected Package Execution Stopping

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


Discuss Unexpected Package Execution Stopping in the microsoft.public.sqlserver.dts forum.



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

Default Unexpected Package Execution Stopping - 10-25-2004 , 02:35 PM






I have a package that, for some reason just stops without providing any
information as to why.

What this package does:
1) Several tasks types are executed in preparation for a controlled loop
2) ActiveX task 'Manage Loop' determines whether to exit or enter loop
3) Loop executes and reaches an ActiveX branch
4) Both branches bring code execution back to a detached execution path via
ActiveX tasks at end, this was done because I could not get 2 Success
workflows to be attached to a single task and work.
5) Detached execution path ends after setting the next step to 'Manage Loop'
using yet another ActiveX task.

All works well and executes 1 complete time but when it gets to the first
step after the ActiveX 'Manage Loop' task it stops without any indication
why. What this step does is select the next row of a table which it is
supposed to work its way through. Assigning the returned values to Global
Variables.

At this point all the ActiveX scripts that are to run have been run
successfully so I don't understand why on such a simple task it would just
stop.

Thanks in advance for any help.

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.