dbTalk Databases Forums  

Problem with Custom Error Handler Task

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


Discuss Problem with Custom Error Handler Task in the microsoft.public.sqlserver.dts forum.



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

Default Problem with Custom Error Handler Task - 06-02-2004 , 04:16 AM






Hi,

I've asked to a solution to a problem earier in this group.
Now I recieved an answer from the Microsoft Developers which I put here:

<From Dev>
This behavior is by design. Whenever a custom task fails by
returning DTSTaskExecResult_Failure then DTS adds an error message to
the error message stack with the text "The task reported failure on
execution." This is so that if the task doesn't send an error
message before it fails then there is something available for display
to the user when the task is double clicked. Furthermore, if the
task reports failure then how would DTS know if the error message
reported by the task is something that should be displayed or due to
some bad code path before the error in the task occurred. Therefore,
a generic error message is stacked stating that the task failed.
<\From Dev>

I doesn't help me much but at least now I know the reason for the behaviour!

Keep up the good work guys!!

Regards,
Stefan Sundström

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.