Reading XML file

[ankita]

Hi All,

I have created a simple job to extract data from xml file and loaded it into sequential file. For e.g, if source is as below,
<Customer>
<FName>
Titi
</FName>
<LName>
Maiti
</LName>
<FName>
Arup
</FName>
<LName>
Roy
</LName>
</Customer>
Then output should be as,
Titi,Maiti
Arup,Roy

But the jobs is creating o/p as,
Titi,
Maiti
Arup,
Roy

As per my understanding, it's passing the newline as in the xml file. Though job stat shows 2 records. Can anyone please help me to format the output properly ?

Thanks in advance !
Ankita

[chulett]

Yes, the newline is simply part of the data when your input file is formatted like that. Strip them from the field in your job using Convert() and CHAR(13).

[ankita]

Thanks chulett ! It has solved the problem.