Hi. I am new to VS and SSIS and I am trying to merge the data in the xml file (attached) via XML Data Source through Data Conversions to a single table in sql. The data appears to be organized via headers in the xsd (attached) . The actual desired index filed is DISPATCH_RECORD_ID or CADNUMBER which both contain the same data. I can set up the xml source with out a problem and I can dataconvert the fields in in each header selected. Where I am lost is get the data together , since I can't join the data points from the xml through a join after conversion because there is no common index.
I am using VS 2005 .