FlatFile Line Splitting

Here are instructions on how to have BizTalk split lines from a flat file into individual messages.

  1. Create a Flat File Schema and name the root node File (which is poorly named, it should be called Message) and make it post fix delimited with Carriage Return Line Feed (Hex 0×0d 0×0a) as the delimiter
    CRLF.JPG
  2. Create the line as a comma delimited record and add the elements in the line
    Comma.JPG
  3. Create the pipeline using the schema that was just created
    Pipeline.JPG
  4. Deploy the solution
  5. Set up the Ports as follows:
  6. Input Port: Name it, Create a recieve location using *.txt as the input pattern and the newly created pipeline
  7. Output Port: Name it, create the output path as %MessageID%.xml as the output pattern, on filters: Set BTS.ReceivePortName as what is created for the input port
  8. Start the Output Port
  9. Enable the recieve location

posted @ Thursday, August 31, 2006 12:00 PM

Print

Comments on this entry:

No comments posted yet.

Your comment:



 (will not be displayed)


 
 
 
Please add 2 and 2 and type the answer here:
 

Live Comment Preview:

 
«March»
SunMonTueWedThuFriSat
28123456
78910111213
14151617181920
21222324252627
28293031123
45678910