XMLBulk load and trigger

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Mavis
    #1

    XMLBulk load and trigger

    Seems the XMLBulkload does not support the "Trigger".
    But I really need to execute some rules after bulk load, anyone can
    give me some hints about this?
    I wonder whether I can fire a trigger in my asp code after I
    execeuting xmlbulkload?
    Or any other ways to fire trigger?

    Thanks for your assistance!

    DeeDee
    Tags: None
    • oj
      #2
      Re: XMLBulk load and trigger

      You would have to bulkload into a staging table then perform Insert into the
      basetable for the trigger to get fired.

      --
      -oj
      Rac v2.2 & QALite!
      http://www.rac4sql.net



      "Mavis" <ddh2739@yahoo. com> wrote in message
      news:ef6b6e26.0 309121631.623f1 52b@posting.goo gle.com...[color=blue]
      > Seems the XMLBulkload does not support the "Trigger".
      > But I really need to execute some rules after bulk load, anyone can
      > give me some hints about this?
      > I wonder whether I can fire a trigger in my asp code after I
      > execeuting xmlbulkload?
      > Or any other ways to fire trigger?
      >
      > Thanks for your assistance!
      >
      > DeeDee[/color]


        Comment

        Previous template Next
        Working...