Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003
    KL, Malaysia

    Red face Unanswered: Check Constraint and DTS Problem


    When using DTS, is it possible trap errors caused by check-constraints?

    For example, I have a check constraint in the first column and another in the second column. If my data does not comply to the rules set in the first column, is there a way for me to check whether my data satisfy the second columns condition?

    Reason being that I would like to validate all my columns and log all the errors of each field ( if any ). But using check-constraints, DTS would only test until the column that has error, and then throws and exception without checking the rest.

    If it is not possible, some expert advice on this issue would be greatly appreciated.

    Also, is there a way for me to know which column and row DTS is processing?


    Save the dugongs!

  2. #2
    Join Date
    Dec 2003

    Re: Check Constraint and DTS Problem

    try to anticipate rather than actuate

    I mean, try to check first if rows you are going to insert conflict with any constraint and log them accurate

Posting Permissions

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