title: Google Analytics xlsx to sql - ssis vs2013
body: <p>I have google analytics xlsx files downloaded in a local folder and trying to import it to sql using ssis in vs 2013.</p>
  
  <p>I am using OLE DB source with connection manager settings:-
  Provider as office 12.0
  file name - file in local path
  advanced extended properties - Excel 12.0
  Delay validation- true for data flow task etc...
  installed Microsoft Access Database Engine 2010 Redistributable</p>
  
  <p>google <a href="https://dataintegrity.wordpress.com/2009/10/16/xlsx/" rel="nofollow noreferrer">https://dataintegrity.wordpress.com/2009/10/16/xlsx/</a></p>
  
  <p><a href="https://social.msdn.microsoft.com/Forums/sqlserver/en-US/e8b5f7c6-bd4f-4f6a-aeef-a011e4b47146/opening-a-rowset-for-failed-check-that-the-object-exists-in-the-database?forum=sqlintegrationservices" rel="nofollow noreferrer">https://social.msdn.microsoft.com/Forums/sqlserver/en-US/e8b5f7c6-bd4f-4f6a-aeef-a011e4b47146/opening-a-rowset-for-failed-check-that-the-object-exists-in-the-database?forum=sqlintegrationservices</a></p>
  
  <p>But always getting error as below:-</p>
  
  <h2>TITLE: Microsoft Visual Studio</h2>
  
  <p>Exception from HRESULT: 0xC02020E8
  Error at Data Flow Task [OLE DB Source [2]]: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80004005.</p>
  
  <p>Error at Data Flow Task [OLE DB Source [2]]: Opening a rowset for "Dataset1$" failed. Check that the object exists in the database.</p>
  
  <p>What other settings i am missing? Please help.</p>