BULK INSERT command has an option to explicitly fire triggers on insert operations. Like:
BULK INSERT Northwind.dbo.[Order Details]
FROM 'f:orderslineitem.tbl'
WITH
(
FIELDTERMINATOR = '|',
ROWTERMINATOR = ':n',
FIRE_TRIGGERS
)
There is no obvious check box in DTS Designer to allow triggers firing. However, unchecking 'Use fast load' check-box just does it: triggerts are invoked!

[показать]