title: "Unspecified Error" when clicking on 'Name of Excel Sheet' for a Excel Source Task
body: <p>I've created an Excel connection. When I create a data flow with an Excel destination and click 'Name of Excel Sheet' I get an "Unspecified Error".  When I look under 'Show Advanced Editor' of the destination I see the following error:</p>
  
  <p><code>Error at blah [Connection manager "DestinationConnectionExcel"]: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80004005.</p>
  
  <p>An OLE DB record is available.  Source: "Microsoft JET Database Engine"  Hresult: 0x80004005  Description: "Unspecified error".
  Error at Insert blah [Destination - blah [199]]: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.  The AcquireConnection method call to the connection manager "DestinationConnectionExcel" failed with error code 0xC0202009.  There may be error messages posted before this with more information on why the AcquireConnection method call failed.
  Exception from HRESULT: 0xC020801C (Microsoft.SqlServer.DTSPipelineWrap)
  </code></p>
  
  <p>I've read through a tons of other post and nothing seems to help. I've tried setting the 'DelayValidation=True' on all the Jet Engine related task. While this allows me to run the package without any errors, I can't edit or change anything. I also can't create new tasks with Excel.  </p>
  
  <p>I've already tried to set 'Run64BitRuntime = false" and that also isn't helping. </p>
  
  <p>Another note, The problem is intermittent. I've been able to work with Excel tasks fine one time after a reboot, then another time its all failing as I described. </p>
  
  <p>Any help would be appreciated. Thanks all</p>