title: Why aren't my triggers firing during an insert by SSIS?
body: <p>I have an SSIS data flow task with an OLE DB Destination component that inserts records into a table with a trigger.  When I execute a normal <code>INSERT</code> statement against this table, the trigger fires.  When I insert records through the SSIS task the trigger does not fire.</p>
  
  <p>How can I get the trigger firing in SSIS?</p>