Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2002
    Posts
    58

    Unanswered: DTS Tranform Data Task On Failure

    How do I set an On Failure when a Tranform Data Task fails? I'm pulling in a text file and if the set the On Failure for the text file connection it says "Defining precedences between the selected items is not valid", and if I set the On Failure for the database connetion is doesn't execute when the tranform data fails. Any ideas on how capture this error?

  2. #2
    Join Date
    Nov 2003
    Location
    Christchurch, New Zealand
    Posts
    1,618
    You set the failure on the tranformation not on the connections. The transformation will fail becuase it can't connect, but the conneciton itself will not cause an "on failure" event.

  3. #3
    Join Date
    Feb 2002
    Posts
    58
    I've tried that as well. I click on the Transform Data Task, then click on my error module and select Workflow>On Failure and it tells me I have fewer than 2 items have been selected. Is there another way to set the on failure for a transform data task?

  4. #4
    Join Date
    Nov 2003
    Location
    Christchurch, New Zealand
    Posts
    1,618
    What version of SQL is this. I just did a quick refresher on SQL 2k to make sure I wasn't talking rubbish. I selected the transformation, then selected my activex script and right clicked Workflow, Workflow Properties. I then clicked New and added the precedence....

Posting Permissions

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