Hi all,
I have a bunch of XML-files that comes every day.
I want to merge all these files to a big single file so that I can load the file into SQL-server one step.
Below is a simplified version of the real file. Only difference is that BusinessPartner is repeated x number of times.
<?xml version="1.0" encoding="iso-8859-1" ?>
<BusinessPartners_Update>
<Body>
<BusinessPartner>
<Customer>
<BusinessPartnerNumber>001</BusinessPartnerNumber>
<BusinessPartnerName>Name1</BusinessPartnerName>
</Customer>
<OrganisationNumber>5560123456</OrganisationNumber>
<AccountGroup>1000</AccountGroup>
<LegalStatus>1</LegalStatus>
<Address>
<Street>StreetName</Street>
<AddressPostalCode>123 45</AddressPostalCode>
<City>CityName</City>
<CountryKey>US</CountryKey>
</Address>
</BusinessPartner>
</Body>
</BusinessPartners_Update>
I have installed MSXML2.DOMDocument.4.0
Can this be automated using a DTS script?
Or how can I merge the XML-files?
/Kent J.
I have a bunch of XML-files that comes every day.
I want to merge all these files to a big single file so that I can load the file into SQL-server one step.
Below is a simplified version of the real file. Only difference is that BusinessPartner is repeated x number of times.
<?xml version="1.0" encoding="iso-8859-1" ?>
<BusinessPartners_Update>
<Body>
<BusinessPartner>
<Customer>
<BusinessPartnerNumber>001</BusinessPartnerNumber>
<BusinessPartnerName>Name1</BusinessPartnerName>
</Customer>
<OrganisationNumber>5560123456</OrganisationNumber>
<AccountGroup>1000</AccountGroup>
<LegalStatus>1</LegalStatus>
<Address>
<Street>StreetName</Street>
<AddressPostalCode>123 45</AddressPostalCode>
<City>CityName</City>
<CountryKey>US</CountryKey>
</Address>
</BusinessPartner>
</Body>
</BusinessPartners_Update>
I have installed MSXML2.DOMDocument.4.0
Can this be automated using a DTS script?
Or how can I merge the XML-files?
/Kent J.