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;
