title: SSIS: An OLE DB Error has occurred. error code 0x80004005, The peer prematurely closed the connection
body: <blockquote>
    <p>SSIS error Code DTS_E_OLEDERROR. An OLE DB Error has occurred. error code 0x80004005. An OLE DB record is available. Source: "Microsoft OLE DB Provider for SQL Server 2016 Analysis Services.” Hresult: 0x80004005 Description: “An error was encountered in the transport layer.”. An OLE DB record is available. Source: "Microsoft OLE DB Provider for SQL Server 2016 Analysis Services.” Hresult: 0x80004005  Description: “The peer prematurely closed the connection.”. </p>
  </blockquote>
  
  <p><strong>Issue encountered:</strong> When trying to run SSAS Cube from SSIS.</p>
  
  <p><strong>Following SQL server setup:</strong></p>
  
  <ol>
  <li>SSIS: SQL Server 2016 version 13.0.5622.0 (OS 2016 Core Server)</li>
  <li>SSAS: SQL Server 2016 version 13.0.5102.14 (OS 2012 Server non-Core)</li>
  </ol>
  
  <p><strong>What we have tested so far:</strong></p>
  
  <ol>
  <li>SSAS: When running SSAS Package directly - No Issues will Occur. Meaning, we remove doubts that concerns issues from SSAS</li>
  <li>SSIS:SQL Server 2016 version 13.0.5622.0 (OS 2012 Server non-Core) - When running the package under this server, issue will not occur.</li>
  <li>SSIS: SQL Server 2016 version 13.0.5622.0 (OS 2016 Core Server) - When running Package under this server, Issue will occur.</li>
  <li>from #3 - Updating Provider from MSOLAP.6 to MSOLAP.7 - Issue still occur.</li>
  </ol>
  
  <p><strong>Process:</strong></p>
  
  <ol>
  <li>Create SSIS with Analysis Service Processing Task</li>
  <li>have connection string : Data Source=;Initial Catalog=;Provider=MSOLAP.7;Integrated Security=SSPI;Impersonation Level=Impersonate;</li>
  <li>Create SSAS Process : Any Process will do as long as it will run</li>
  <li>Run SSIS &lt; Error will occur once SSIS executed</li>
  </ol>
  
  <p>Has anybody encounter the same or the issue with similar like ours?</p>