title: Import Data from Excel using SSIS
body: <p>I have an Excel data source with 9 sheets. If I set the connection manager's <code>RetainSameConnetion = True</code>, the import takes seconds. If I set the property to <code>False</code> then it takes about a minute. So far so good. However, at the end of the package I want to move the Excel file to an archive folder. If the <code>RetainSameConnection</code> is set to True the file is locked and can't be moved.  </p>
  
  <p>Is there a way in a script to release the connection so that the file can be moved at the end. I've tried <code>DTS.Connections("xxxx").ReleaseConnection(y)</code> but that doesn't seem to work, whatever I set the value of y to.</p>