flat file schema needs help

Home Page Forums BizTalk 2004 – BizTalk 2010 flat file schema needs help

Viewing 1 reply thread
  • Author
    Posts
    • #21064

       I’ve been banging my head off the wall on this ff:

      Althought it doesn’t appear that way, all lines are 90 char. long and positions of data are constant.  This represents an order.  There is only one line 0 (order header), 2 line 1 (customer info),  2 line 2 (order info), 1 or more line 4 (items).

      I’ve tried different ways without total success. I only get the first order  Any ideas?

      0    3395081014                              CMD_081014_3ATQBOV023                      
      1FERME DU COTEAU                                                                        
      1349 Rg du 5                                  St-Stanislas-de-Kostka QC J0S1W0          
      2                                                                          10     8012608
      2                                                                        081014PRO1166645
      4     9I001   0124000105707712    F       I0010124000105707712 4    BOV                 
      4     1I001   1124000100405820   NF       I0011124000100405820 4    BOV                 
      1DEMERS PIERRE                                                                          
      1172 2E Ligne                                 Napierville QC J0J1L0                     
      2                                                                          10     8012591
      2                                                                        081014PRO1250858
      4    10I001   0124000105707326    F       I0010124000105707326 4    BOV           

    • #21065

       Are you sending this file or recieving the file? If you are recieving the file you create a recieve pipeline (select flat file disassembler and set document) and it will break the file into single files easier for mapping.

Viewing 1 reply thread
  • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.