Issue with getting data from XML file by using SSIS
Those attributes are on different levels so this is kind of the way the XML Source works.  You have a couple of options:


Use Sort options with a Merge Join to bring the two sections back together, something like this:





Capture the XML in a variable, pass it to a stored proc as a parameter and shred it in the proc, using something like this:

DECLARE @xml XML = '&lt;?xml version="1.0" encoding="iso-8859-1"?&gt;
&lt;exchangerates type="Exhange rates" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" refamt="1" refcur="DKK" author="Bank"&gt;
    &lt;dailyrates id="2016-07-22"&gt;
        &lt;currency rate="505.47" desc="Australian dollars" code="AUD"/&gt;
        &lt;currency rate="380.36" desc="Bulgarian lev" code="BGN"/&gt;
        &lt;currency rate="205.85" desc="Brazilian real" code="BRL"/&gt;
        &lt;currency rate="515.31" desc="Canadian dollars" code="CAD"/&gt;
        &lt;currency rate="684.99" desc="Swiss francs" code="CHF"/&gt;
        &lt;currency rate="101.21" desc="Chinese yuan renminbi" code="CNY"/&gt;
    &lt;/dailyrates&gt;
&lt;/exchangerates&gt;'


SELECT 
    dr.c.value('@id', 'DATE') id,
    c.c.value('@rate', 'MONEY') rate,
    c.c.value('@desc', 'VARCHAR(50)') [desc],
    c.c.value('@code', 'VARCHAR(50)') code
FROM @xml.nodes('exchangerates/dailyrates') dr(c)
    CROSS APPLY dr.c.nodes('currency')  c(c)



Good luck!