I need to create an XML file populated by data from a CSV file.
I have the following XMLSchema template:
All the data highlighted in BOLD
above will come from an excel (csv) file.
At the moment as a work around im using a MS Word Mail Merge, this is not ideal, can his be done using a SSIS package?