I have a request to create an XML from a SQL query from a Oracle DB and FTP it to a FTP site. The query lists SalesReps and their attributes including the zipcodes that make up their sales territory. So, John Smith's sales territory could be comprised of 01022, 01026, 01027,01028 zipcodes.
I built a process that works fine, using tOracleInput, tFileOutputXML, tFTPConnection, tFTPPut components.
The problem is the XML is required to use zipcode to and from ranges:
<SalesReps>
<SalesRep>
<Zipcode>
<ZipcodeFrom>01022</ZipcodeFrom>
<ZipcodeTo>01028</ZipcodeTo>
</Zipcode>
</SalesRep>
</SalesReps>
Is it possible to generate an XML with this format? And if so which components are required.
