Post reply

DTS and INSERT Triggers

  • June 16, 2003 at 12:59 pm

    #151858

    Hello everyone,

    I have a DTS package that imports data from an Oracle database to a SQL Server database. The table that the data is being loaded into has an INSERT trigger defined on it that copies the newly inserted record into a history table. However, when I run the DTS package to do the load, the data is loaded okay, but the trigger doesn't seem to fire because the history table is never refreshed with the most recent data loaded. Does anyone know what's causing this and if it can be fixed?

    Thanks,

    Jason

  • June 16, 2003 at 1:45 pm

    #461592

    Hello.

    By default a Transform Data Task is set to 'Use Fast Load' which causes it to do a bulk insert. If you click off this option (and thereby go to a row by row insert process) then the trigger shouldn't be suppressed.

    Everett



    Everett Wilson
    ewilson10@yahoo.com

  • June 16, 2003 at 3:04 pm

    #461601

    Thanks Everett! I will give it a try later in the week when they get data back into the Oracle database and let you know if that did the trick.

    Jason

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply