Trigger doesn't fire on BCP

[TheJFM]

Hi

I have an after insert trigger on a table.

It fires on a table to table insert.

However an insert by bcp from a sysbase server fails to fire the trigger.

Any ideas people?

** Don't reach for the moon when you have the stars. ;-) TheJFM **

 

[JamesLean]

This is normal default behaviour for bulk copy operations (bcp, BULK INSERT). You need to specify you want to fire the insert triggers using the -h flag in your bcp statement:

-h"FIRE_TRIGGERS"

--James

 

[TheJFM]

Thanks James

Unfortunately our Sybase deveoper on Unix has informed me that their BCP does not support hints.

Any othjer ideas?

Thanks

** Don't reach for the moon when you have the stars. ;-) TheJFM **

 

[JamesLean]

Sorry, I don't use Sybase so I don't know what its version of bcp is capable of. If your developer doesn't think you can specify to fire triggers then you may need to rethink your data transfer.

Can you use bcp from your SQL Server end and grab the data from Sybase?

Or you could get the data into a holding table and then simply INSERT it into your main table - which will fire the triggers as normal.

--James

 

[TheJFM]

Thanks

The problem is that the data comes into Sybase on an adhoc basis. When it arrives the Sybase guys push it to us.

I want our trigger to fire when and if the data arrives. I really didn't want to give the access to run an sp on our servers but I may have no choice.

** Don't reach for the moon when you have the stars. ;-) TheJFM **