Hi,
I am trying to store the (EDI)flat file data into database tables . I am using the SQL Adapter and Updategram to do this job. I am using flat file Shema for mapping in the Orchestration .
Tranport is File , URI is input folder and pipe line is Default XML receive in the Receive port.
When I drop the XML files in the input folder it is store in the database success fully.
If I drop flat file in the input folder i am getting disassembler issue. Before I drop flat file, I change the Receive port's URI to *.txt message type and piple line to Default PassThru.
How can i store the flat file data into database with out creating another map for converting the flat file to XML?
I am not sure how this process works.
I am new to BizTalk.
Thank you in advance.