title: SSIS - OleDB connection not updating data, inserted thru SQLBulkCopy with SQL Connection
body: <p>I have created Ole DB connection to execute different SQL task across SSIS package. Its working fine too.</p>
  
  <p>In one of task where i need to do insert data into table, used SQLBulkCopy as i have dynamic tables and columns based on getting files from different sources.</p>
  
  <p>SQLBulkCopy only works with SqlConnection, so i opened SqlConnection, executed SqlBulkCopy. This is also working fine.</p>
  
  <p>After done with SqlBulkCopy, i have created Sql Task which updates metadata of inserted rows, for e.g. Count, Min &amp; Max date and so on in different table.
  This table is not getting updated and if i execute stored procedure from Sql Management Studio, it works as expected.</p>
  
  <p>So my assumption is that, Ole DB connection is not able to get the latest data Data inserted thru SQL Connection.</p>
  
  <p>I may be wrong, but not sure why i can see sql execution task successful but still table is not updated.</p>
  
  <p>Am i missing anything here?</p>