cancel
Showing results for 
Search instead for 
Did you mean: 

SFTP parameters to read the flat file in a single field

ravi_teja14
Participant
0 Kudos

Hi Team,

we tried to pull the records from flat file by using SFTP sender Adapter parameters message Transform bean. The records values have to be process to target structure by using UDF based on the fixed lengths. The sender SFTP adapter failed with the error message as prolog, unable to transform to xml Sax parser error

UDF from the blog - In the blog the team has achieved by using the file adapter.

If we remove the swcv in the sender agreement then the total is processing successfully but here we have to pass the records to Message Mapping/Operation Mapping because we are using UDF to send the required values to Target structure based on the length.

please share the parameters to pull the records from flat file.

example flatfile-

Aaaaaabbbbbccccc

Bdddddeeeeeffff

Cggggghhhhhiiiii

Required output by the SFTP adapter-

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

<ns0:MT_Input xmls:ns0="Namespace">

<Recordset>

   <row>aaaaabbbbbccccc</row>

</Recordset>

<Recordset>

   <row>dddddeeeeeffff</row>

</Recordset>

<Recordset>

   <row>ggggghhhhhiiiii</row>

</Recordset>

</MT_Input>

Thanks,

Ravi

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

what are the parameter values you use for the message Transform bean