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