Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2002

    Unanswered: Tigger Will Not work with DTS package

    I have a table that does calculations on logs that are imported from different server. I have trigger to clean data on insert or update.

    When I run DTS package to insert records, it will not work. I can get the tigger to work by doing a simple update on a feild.

    My question,

    Can I add something to the tigger to make the tiggers work with dts insert?
    I can update a record after the transformation, but it just seems like it half-as_ed
    Jon Nelson

  2. #2
    Join Date
    Feb 2002
    Houston, TX
    Issue an update statment that changes more than one record and see if your trigger still owrks. Also post your trigger code, maybe one of use can spot something.
    Paul Young
    (Knowledge is power! Get some!)

Posting Permissions

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