dbTalk Databases Forums  

Trigger not fireing

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Trigger not fireing in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Watherton
 
Posts: n/a

Default Trigger not fireing - 09-15-2004 , 02:13 AM






Hi people, please can you help me on this one. I have developed a DTS package
that transfers data from a csv file into a table - simply stuff yeah? Ok I
then saved the package as a .bas file and converted the vb code into a c#
class.

When i run the dts package from Enterprise Manager the trigger associated
with the destination table fires, however when I run the c# class the trigger
does not fire.

I have set the Bulk mode to full and I am impersonating the computers admin
account within the class.

Any help would be grately appreciated.

Cheers

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.