Skip to Content
0
Former Member
Sep 13, 2007 at 05:35 PM

File content conversion tab delimited

2213 Views

Hi Experts,

I am trying to do scenario file to JDBC.

the source file is tab delimited file the file as

sno empname empno country

1 ETY 1246 IN

2 EPS 1247 IN

I need to transfer the data into Data base table

source structure as follows

<?xml version="1.0" encoding="UTF-8"?>

<ns0:MT_PRY

xmlns:ns0="http://product.com/prvsoup">

<DT_PRY>

<ID>1</ID>

<empname>ETY</empname>

<empno>1246</empno>

<contry>in</contry>

</DT_PRY>

</ns0:MT_PRY>

I don't want to update the first row i.e field names.

Can any one give the Content conversion parameter in Comunication channel.

Regards

ramu