Dts

[babuyadav]

I have table A and B ..Table A has trigger which is to be fired when i am
inserting somerows into A. I am trasfering data from Table B to Table A
Through DTS. But data are getting transfered but trigger is not firing..

If i am inserting some rows through query analyser the trigger which i have
written under Table A It's getting fired..

Give me a solution.

[Craig]

Your DTS is using BCP which is not issuing an insert, therefore, no trigger gets fired.

Change your DTS to run SQL code that does an insert and it will work.


------------
babuyadav at 11/21/00 6:21:39 AM


I have table A and B ..Table A has trigger which is to be fired when i am
inserting somerows into A. I am trasfering data from Table B to Table A
Through DTS. But data are getting transfered but trigger is not firing..

If i am inserting some rows through query analyser the trigger which i have
written under Table A It's getting fired..

Give me a solution.