Post reply

Trigger does not fire during DTS import

  • September 30, 2003 at 5:59 am

    #159898

    Hi All,

    When I execute a DTS import the trigger does not fire that's in the table.

    Is there anybody that can help on this topic

    Thanks a lot in advance

    Greetings Alexander

  • September 30, 2003 at 5:57 pm

    #476468

    How are you importing the data in DTS, Bulk-Insert, Datapump??

    Hope this helps

    Phill Carter

    --------------------

    Colt 45 - the original point and click interface

    --------------------
    Colt 45 - the original point and click interface

  • October 1, 2003 at 1:08 am

    #476486

    Hi Phill,

    Uh, actually I have no idea, I wrote a DTS which imports data from a flat ascii file into the employees table in the Northwind database.

  • October 1, 2003 at 4:01 am

    #476515

    Try this...

    unceck the the "use fast load" check box in the transformation properties-->option tab.

  • October 1, 2003 at 5:31 am

    #476524

    Thanks a lot Joe this finally works

Viewing 5 posts - 1 through 4 (of 4 total)

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