 | |
DTS Datapump and Trigger
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
DTS Datapump and Trigger -
06-08-2004
, 01:12 PM
#2
| |||
| |||
|
|
I've setup an insert trigger on a table, however when I execute a DTS package that runs a datapump into that table the trigger does not fire? Is there a method for fireing a trigger when using a datapump? Thanks in advance. |
#3
| |||
| |||
|
|
Remove the "Fast Load" check from the last tab in the setup of your DataPump -- -- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org "TCG_GILBERT" <TCG_GILBERT (AT) hotmail (DOT) com> wrote in message news:19c5201c44d84$23068c30$a501280a (AT) phx (DOT) gbl... I've setup an insert trigger on a table, however when I execute a DTS package that runs a datapump into that table the trigger does not fire? Is there a method for fireing a trigger when using a datapump? Thanks in advance. |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.