Using OnError in a custom task in VC++.

• gadi001

  SSC Rookie

  Points: 26

  More actions

  December 10, 2003 at 1:33 am

  #107396

  I wrote a custom task in VC++.

  I used the DtsEvents->OnError to report an error.

  I designed and run the package from the package designer

  I tried to set the value of *pbCancel to 1 and 0 in order to stop the DTS package execution after the error is reported but none worked.

  (Idefined *pbCancel as short instead of BOOL due to an error in compilation when using BOOL)

  Whe running the package from the designer If after calling DtsEvents->OnError I terminate the custom task with DTSTaskExecResult_Failure then the task really fails but I do not see my error message. On the other hand if I finish it with DTSTaskExecResult_Success then I get to see my message, but the task does not fail.

  Any idea?

  Can somebody point out to a good documentation / usage example of DtsEvents->OnError from VC++

• philcart

  SSC-Forever

  Points: 47797

  More actions

  December 10, 2003 at 3:38 pm

  #485623

  I don't do anything with VC++, mainly stick to VB and C#.

  You could try these to see if they give you some ideas,

  http://www.codeproject.com/database/dts.asp

  http://www.sqlmag.com/Articles/Index.cfm?ArticleID=6196&pg=2

  http://support.microsoft.com/default.aspx?scid=kb;EN-US;319985

  Hope this helps

  Phill Carter

  --------------------

  Colt 45 - the original point and click interface

  --------------------
  Colt 45 - the original point and click interface