Microsoft Share Point Connector error: Error during download: Unable to read data from the transport connection: Connection reset by peer

[marciomgm]

I'm using data load with XLS and CSV files contained in my site in Microsoft Share Point.
The problem is intermittent, sometimes I can complete the charge and other times I don't it stops at different times.
Is there any way to handle this error?

(Connector error: Error during download: Unable to read data from the transport connection: Connection reset by peer.)

LIB CONNECT TO 'Sharepoint';

LOAD
Name as [ListFiles.Name];

SELECT UniqueId,
Name
FROM ListFiles
WITH PROPERTIES (
subSite='/sites/meusite/',
folder='/sites/meusite/Documentos Compartilhados',
maxResults=''
);

for each File in FieldValueList('ListFiles.Name')
  trace $(File);
  tabela:
  LOAD 
    dataPostagem,
    codigoServico,
    descricaoServico,
    quantidadeItens,
    peso,
    valorUnitarioServico,
    valorServico,
    numeroDocumento,
    etiqueta as codigo_rastreamento,
    valorDeclarado,
    valorDesconto,
    unidadePostagem,
    cepOrigem,
    municipioCepOrigem,
    ufCepOrigem,
    cepDestino,
    municipioCepDestino,
    ufCepDestino
	FROM [lib://Office_365_Sharepoint/Documentos Compartilhados/tabela/$(File)]
	(XmlSimple, Table is [FATURA/itemCorpo]);
next File;

[Mfarias86]

I´m having the same issue, tried with 2 different sharepoint sites, different conexions too. It happens with single files and FOR statements as in Marcio example. Its pretty random, I had the error a few times in the past, but for the last few weeks it got way worse, nothing is running properly now.

[AdamBS]

I put some code in to test if the xlsx was modified in the last 3 days. Result is I read less files.  My metadata connector never errored, but the code similar to @marciomgm would error.  It was odd to me because the failing file kept changing - almost like SharePoint was hitting some limit.  I did not get the connection reset by peer - just a blank error.  Have stability since reducing the number of files.