Usenet.com

www.Usenet.com

Group Index

Comp Thread Archive from Usenet.com

<-- __Chronological__ --> <-- __Thread__ -->

Problem with trigger and DTS



I have a DTS import package that takes an Excel file and imports into an SQL
table.  I also have a trigger set on that same table when a new row is
inserted.  When a new row from the DTS is inserted, the trigger is supposed
to execute, but it doesn't.  I've unchecked the 'Fast Upload' but it still
doesn't run.  If I manually add a row in the table itself, the trigger runs
perfectly, so I know that it should work.  It just doesn't work with the
DTS.  However, I just noticed that it will work with a DTS package if I run
it from the DTS designer.  If I run it using a schedule or right-click on
the DTS package name and select Execute Package, it won't work!  Very odd.
Can anybody help me with this?  I appreciate it.

Ed





<-- __Chronological__ --> <-- __Thread__ -->


Usenet.com



Please check out one of the premium Usenet Newsgroup Service Providers below for access to Usenet.