| Wim |
| Newbie |
|
|
|
|
| None Specified |
|
| Thursday, October 29, 2009 |
| Thursday, October 29, 2009 12:36:47 PM |
2
[0.01% of all post / 0.00 posts per day] |
|
Thank you very much. It works!
|
Hi,
We use AltovaXML for XML schema validation. I want to use it for XML translation to CSV files too. The transformation itself works excellent, but AltovaXML always puts an XML declaration line on top of the CSV files: Code:<?xml version=1.0 encoding=UTF-8?>
The next program (DTS of SQL Server) in the process chain can't cope with this file format. I can instruct the DTS to start processing from line 2, but still it will always look at the very first line to know the column names and there it finds the XML declaration line.
This is what AltovaXML generates now:
Code:<?xml version=1.0 encoding=UTF-8?>
Column1|Column2|Column3|Column4
Value1|Value2|Value3|Value4
Value11|Value12|Value13|Value14
This is what I want:
Code:Column1|Column2|Column3|Column4
Value1|Value2|Value3|Value4
Value11|Value12|Value13|Value14
Can I instruct AltovaXML not to generate this XML declaration line? or should I rely on post processing the output with GREP or something like that to filter out the first line?
AltovaXML and the DTS are called from a .BAT batch file.
|
|
