locked
Flat file with Header information RRS feed

  • Question

  • hi,

    here i am getting Source as Flat file with header and i need to remove header and store the data into DB, here i am getting different Header information and i need not worry about the Header info , just i need to pass the data only.

    please give me some links.

    Thanks in advance 

    Chinna


    • Edited by GKReddy88 Monday, December 16, 2013 7:29 AM
    Monday, December 16, 2013 7:09 AM

Answers

  • You have many alternative  solutions one of these solutions:

    1. Generate a flat file schema using Flat File wizard and ignore the header record
    2. Create map to map from schema with header to schema without header then add it to inbound maps in your receive port
    3. In custom pipeline, you remove header.
    4. You can xpath the body block and assign it to xmldocument message inside your orchestration

    I hope this will help you



    • Marked as answer by GKReddy88 Monday, December 16, 2013 9:55 AM
    Monday, December 16, 2013 9:33 AM

All replies

  • You have many alternative  solutions one of these solutions:

    1. Generate a flat file schema using Flat File wizard and ignore the header record
    2. Create map to map from schema with header to schema without header then add it to inbound maps in your receive port
    3. In custom pipeline, you remove header.
    4. You can xpath the body block and assign it to xmldocument message inside your orchestration

    I hope this will help you



    • Marked as answer by GKReddy88 Monday, December 16, 2013 9:55 AM
    Monday, December 16, 2013 9:33 AM
  • hi thanks for your reply 

    here i am getting header info and values are in same file not in seaparate files.

    Monday, December 16, 2013 10:11 AM