May 16, 2008 at 4:09 am
Hi Folks!
I've created a lead-table with an instead-of-trigger for insert,delete,update. The trigger distributes the data to different sub-tables.
If I do a bulk insert from file via management studio query, everything works fine: The records inserted into the lead-table are distributed to the subtables.
If I do the same from my application which has an OleDb connection with fastload property set on and fastload option FIRE_TRIGGERS set, the instead-of-trigger is ignored and all records are written into the lead-table.
Has anyone encountered a similar problem and knows a proper solution for it?
Many pre-thx in advance!
cu,
Andreas
May 16, 2008 at 6:21 am
[font="Verdana"]Post your Bulk Insert query coz you need to mention (might be, u have already mentioned) FIRE_TRIGGER option inside the WITH clause. Triggers won't fire incase of bulk insert. You need to ask them to fire by mentioning FIRE_TRIGGER option inside the WITH caluse of BULK INSERT.
Post your Bulk Insert query.
Mahesh[/font]
MH-09-AM-8694
May 16, 2008 at 6:29 am
Re-Hi!
I've already added the FIRE_TRIGGERS hint to the BULK INSERT query statement as well as to the fastload options in my OleDb-Application. In result the BULK INSERT query works fine whilst the bulk insert via OleDb ignores the trigger although the FIRE_TRIGGERS hint is set.
Any suggestions?
cu,
Andreas
May 16, 2008 at 6:36 am
[font="Verdana"]Well in that case change the connection type and try. This is to just confirm where the problem is.
Mahesh[/font]
MH-09-AM-8694
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply