title: How to log each container and task details into a table in SSIS
body: <p>I have a package which contains several containers and each container have multiple tasks in it like below.</p>
  
  <p><img src="https://i.stack.imgur.com/6Nx7K.png" alt="enter image description here"></p>
  
  <p>during package execution, i need to log each container and task details into a table like below.</p>
  
  <pre><code>LogID  Container        Task                        Status   Error                                       LoggedOn
  1      SEQ - Customer   truncate customer table     SUCCESS                                              2015-03-31 02:22:50.267
  2      SEQ - Customer   create temp table to store  SUCCESS                                              2015-03-31 02:22:50.267
  3      SEQ - Customer   DF - Loading Customers      SUCCESS                                              2015-03-31 02:22:50.267
  4      SEQ - Customer   Validating Customers        FAILED   Failed to convert from varchar to bigint    2015-03-31 02:22:50.267
  </code></pre>
  
  <p>If any error occurs at any particular task, it should log error description in error column in table.Please help me how to achieve this through event handlers or logging in ssis.</p>