I'm trying to use the SQLXMLBulkload object in Visual Basic to insert new records received as XML files into a SQL Server database. The insertion itself works perfectly - nice and quick, too. However, it appears to be ignoring a trigger I have set on the table in question. Should I have expected that, and is there any way around it?
The whole idea behind a bulk load operation is speed - so these operations are minimally logged and triggers are ignored. There is a hint that can be used on bulk load operations called FIRE_TRIGGERS - however, I believe this hint may not exist for SQLXMLBULKLOAD.