dbTalk Databases Forums  

should disabled tasks cause calling packages to fail?

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


Discuss should disabled tasks cause calling packages to fail? in the microsoft.public.sqlserver.dts forum.



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

Default should disabled tasks cause calling packages to fail? - 01-31-2006 , 10:52 PM






I have an execute package task that calls another package containing a
disabled task which is a precedent for a analysis services processing task.

The processing task goes green with no discernible errors in the execution
results, but the execute package task fails with the following results:

"Warning: The Execution method succeeded, but the number of errors raised
(1) reached the maximum allowed (1); resulting in failure. This occurs when
the number of errors reaches the number specified in MaximumErrorCount.
Change the MaximumErrorCount or fix the errors.

"Task CallProcessPackage failed"

I removed the disabled task and the calling package succeeded. However it's
convenient to be able to leave the disabled task in the control flow and
enable when needed. Is there a way I can achieve this?

Thanks in advance,
David
(all SQL2K5)

Reply With Quote
  #2  
Old   
Allan Mitchell
 
Posts: n/a

Default Re: should disabled tasks cause calling packages to fail? - 02-01-2006 , 02:49 AM






Hello David,

Ok so you are using SSIS here. You should not have disabled tasks in the
Workflow in Production and if you do then they behave differently to DTS
2000. Have a look here

http://www.sqlis.com/default.aspx?85

You should IMHO handle a task executing or not executing based on precedence
constraints and expressions on those constraints

http://www.sqlis.com/default.aspx?306


Allan

Quote:
I have an execute package task that calls another package containing a
disabled task which is a precedent for a analysis services processing
task.

The processing task goes green with no discernible errors in the
execution results, but the execute package task fails with the
following results:

"Warning: The Execution method succeeded, but the number of errors
raised (1) reached the maximum allowed (1); resulting in failure. This
occurs when the number of errors reaches the number specified in
MaximumErrorCount. Change the MaximumErrorCount or fix the errors.

"Task CallProcessPackage failed"

I removed the disabled task and the calling package succeeded. However
it's convenient to be able to leave the disabled task in the control
flow and enable when needed. Is there a way I can achieve this?

Thanks in advance,
David
(all SQL2K5)



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.