Hi All,
I’ve got a need to pull data from SQL Server and write it out to an XML file so it can be loaded into another system. I’ve been supplied the schema so I’ve loaded it into DI (11.5) so it knows the format of the XML file.
I’ve built a dataflow and connected the source table to the target XML using a query (see screenshot)… but that’s as far as I’ve got.
The technical manual seems to only deal with importing from XML files and doesn’t go into a whole lot of detail about writing to them. In the query most of the target columns appeared to be greyed out and when I can access them (clicking Make Current seems to enable this??) and map them I’m faced with EMPTY_NAME errors when I try to run the job.
Can anyone help with the basics? I’m pretty comfortable using DI to do everything else, it’s just thrown me with XML
clynham 
(BOB member since 2007-08-17)
(BOB member since 2004-12-17)
(BOB member since 2007-08-17)