Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2003
    Posts
    33

    Unanswered: How to catch error and retry AFTER dts script step has ran

    hello,

    i am trying to figure out how to check for failure or success AFTER the script task has ran.

    its a piece of cake to write script logic that runs before the task but how do i check things and decide to retry AFTER a script task has ran?

    i want to check for an error after a large table replication and if it detects that there was an error i want to RETRY.

    dts does not seem to have this one specific piece of functionality. am i overlooking something?

  2. #2
    Join Date
    Feb 2003
    Posts
    33
    alright... i am closer to figuring this out although the solution seems a bit complex.

    http://www.sqlmag.com/Articles/Index...leID=6196&pg=2

    the WROX book that i bought on DTS "DOES NOT EVEN COVER THIS TOPIC" . it covers reactive error handling but doesn't say a word about proactive error handling.

    i have a java programming background. can anyone see this from my point of view and give me a hint?

    this reminds me of using the "onStart" and "onLoad" methods of ASP programming but it doesn't seem to be quite as simple to use...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •