dbTalk Databases Forums  

Execute Package Task continues after failure

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


Discuss Execute Package Task continues after failure in the microsoft.public.sqlserver.dts forum.



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

Default Execute Package Task continues after failure - 04-18-2005 , 09:29 AM






I have several packages that are called from one "loader" package. The
loader package makes use of the "Execute Package Task" and joins all these
packages in string of "On Success" workflow objects.

The issue is that regardless if the individual package succeeds of fails the
loader continues cause problems.

I want the loader package to stop in case of a failure in a package.

Any thoughts


Reply With Quote
  #2  
Old   
Darren Green
 
Posts: n/a

Default Re: Execute Package Task continues after failure - 04-18-2005 , 10:27 AM






Set Fail on first error on in the child package. This option is on Package
Properties.


Darren Green
http://www.sqldts.com
http://www.sqlis.com

"LP" <LP (AT) discussions (DOT) microsoft.com> wrote

Quote:
I have several packages that are called from one "loader" package. The
loader package makes use of the "Execute Package Task" and joins all these
packages in string of "On Success" workflow objects.

The issue is that regardless if the individual package succeeds of fails
the
loader continues cause problems.

I want the loader package to stop in case of a failure in a package.

Any thoughts




Reply With Quote
  #3  
Old   
LP
 
Posts: n/a

Default Re: Execute Package Task continues after failure - 04-18-2005 , 10:58 AM



Hi Darren,

Thanks for getting back with me. I did that just 5 minutes after I sent the
question.

LP

"Darren Green" wrote:

Quote:
Set Fail on first error on in the child package. This option is on Package
Properties.


Darren Green
http://www.sqldts.com
http://www.sqlis.com

"LP" <LP (AT) discussions (DOT) microsoft.com> wrote in message
news:ECE9D273-1C81-4499-9DF3-DA597D768904 (AT) microsoft (DOT) com...
I have several packages that are called from one "loader" package. The
loader package makes use of the "Execute Package Task" and joins all these
packages in string of "On Success" workflow objects.

The issue is that regardless if the individual package succeeds of fails
the
loader continues cause problems.

I want the loader package to stop in case of a failure in a package.

Any thoughts





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.