Post reply

Fire trigger when IMPORT bulk data using import task.

  • March 22, 2012 at 10:48 am

    #253531

    Hi Experts,

    I have a AFTER trigger that is fired after a insert, delete, update activity on a table.

    My trigger is not working when data is imported into table using import task.

    How can I make the trigger run after data is imported into the table.

    Tanx 😀

  • March 22, 2012 at 10:53 am

    #1462891

    How are you doing the bulk import, SSIS, BCP, some other method?

  • March 22, 2012 at 11:37 am

    #1462913

    If using BCP, you need to use the -h switch with the FIRE_TRIGGERs hint.

    If using BULK INSERT (T-SQL) you need to use the WITH FIRE_TRIGGERS option.

    If using SSIS, you need to select the Fire triggers option on the Bulk Insert Task Editor Options page.

  • March 28, 2012 at 5:38 am

    #1465590

    Hi Lynn,

    Thanks a lot for your help.

    Actually im importing the values using import export wizard.

    Tanx 😀

  • March 28, 2012 at 7:16 am

    #1465640

    Eswin (3/28/2012)

    Hi Lynn,

    Thanks a lot for your help.

    Actually im importing the values using import export wizard.

    If you save the package, you can edit it with BIDS to make the appropriate change. Not sure if you can do it through the wizard.

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

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