Turning off the fast load option on your DTS transformation will allow the trigger to run.  Also be sure as mention above that your trigger will work when multiple inserts...