ETL stops responding when reading large xml files

XML file of 70 mb continuously fails to load (we even left it alone for over 1,5 hours).
Data restriction load does not work on loading the file itself.
Is there anything we are missing?

Example of the xml file is stored here: we.tl/t-KAd7dClky0https://we.tl/t-KAd7dClky0

For transposing the xml we use this transform script:

1) I am unable to download the example.
2) We do not know which software you are using or version or edition or is it actually our software

1) we.tl/t-KAd7dClky0
2) Advanced ETL Processor Enterprise (64 bit) version: 6.3.7.26

What are you trying to do with your file?
Are you trying to load it into the database or convert it into another XML format?

Hey Mike

As it is an XML where the records contain attributes, so I need to transform them.
The issue however is not related to this XSL transformation. When I try to read the XML (even without the XSL transformation) ETL freezes and after 1,5 hours I need to end the process in order to continue. This is not only on my machine.

We have reproduced the problem and we need time to investigate the issue.

The reason for my question is if you loading data into the database you can just convert XML file into CSV and load it instead.
That would be a much faster option.

You can use the XLST for conversion.

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl=" www.w3.org/1999/XSL/Transform ">
<xsl:output method="text" encoding="UTF-8"/>
<xsl:template match="DFMS_VariableValues">
<xsl:text>@DFMS_PeriodDimensionID,@DFMS_PeriodTypeID,@DFMS_PeriodTypeValue,@DFMS_PeriodYear,@DFMS_PeriodValue,@DFMS_ValueNumeric,@DFMS_VariableID,@DFMS_VariableValueID
</xsl:text>
<xsl:text>&#xA;</xsl:text>
<xsl:for-each select="DFMS_VariableValue">
<xsl:value-of select="@DFMS_PeriodDimensionID"/>
<xsl:text>,</xsl:text>
<xsl:value-of select="@DFMS_PeriodTypeID"/>
<xsl:text>,</xsl:text>
<xsl:value-of select="@DFMS_PeriodTypeValue"/>
<xsl:text>,</xsl:text>
<xsl:value-of select="@DFMS_PeriodYear"/>
<xsl:text>,</xsl:text>
<xsl:value-of select="@DFMS_PeriodValue"/>
<xsl:text>,</xsl:text>
<xsl:value-of select="@DFMS_ValueNumeric"/>
<xsl:text>,</xsl:text>
<xsl:value-of select="@DFMS_VariableID"/>
<xsl:text>,</xsl:text>
<xsl:value-of select="@DFMS_VariableValueID"/>
<xsl:text>&#xA;</xsl:text>
</xsl:for-each>
</xsl:template>
</xsl:stylesheet>

On my computer, it takes 14 seconds to convert.
The CSV file is much smaller than the original XML (6Mb vs 36Mb)

Please also have a look at this example
www.etl-tools.com/automation/0010-how-to...-delimited-file.html