question

Neeraj 3 avatar image
Neeraj 3 asked

Import Data & Trigger

Hi, I am importing an excel file in a table thru Import Data Task, but the trigger on the table doesn't fire :( Is there a way I can tell SQL Server Exp. Edition 2008 R2, to fire the trigger on the destination table with the Import Data Task? Or is there any other way to import the excel file into a table so that the trigger on the table fires? Thanks. Neeraj
exceltriggerimport-data
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Sri 1 avatar image
Sri 1 answered
"Use fast load" option...This will run slower, but will fire triggers
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Neeraj 3 avatar image
Neeraj 3 answered
Thanks Sri, but "Use Fast Load" option still doesn't fire the trigger. I am looking into the Integration Service Project! Is that the place I am supposed to check or is there any other place which has "Use Fast load" option.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.