title: How to Close SSIS Connection with RetainSameConnection = True
body: <p>I have an ODBC connection with RetainSameConnection set to True.</p>
  
  <p>I think it is remaining open after my package completes, because simple queries like <code>SELECT COUNT(*) FROM MyTable</code> directly from my query browser hang.</p>
  
  <p>Does this sound likely?  How can I prove / disprove my theory?  Is there a way to force this connection to close in SSIS after I've finished with it?</p>