locked
Generate ASCII records with Headers RRS feed

  • Question

  • Hi all

    I have an ASCII schema that currently generate 5 attributes

    Current =

    ABC,August,3,2012,48
    EDF,Dezember,4,2012,37

    I need to make changes to the Schema to generate the headers..

    Expected Solution =

    Partner,Monat,Quartal,Jahr,TransaktionSumme

    ABC    ,August,    3,   2012,    48
    EDF,    Dezember,4,   2012,   37

    Where can I make changes to the ASCII Schema to be able to generat the Column headers with the resultset.?

    Thanks in Advnace

    ps. Tutorial or example ASCII schema will do


    AKE

    Tuesday, January 29, 2013 7:48 PM

Answers

  • Do refer to this thread for help.


    Please mark the post answered your question as answer, and mark other helpful posts as helpful, it'll help other users who are visiting your thread for the similar problem, Regards -Rohit Sharma (http://rohitt-sharma.blogspot.com/)

    • Marked as answer by Akaschmid Wednesday, January 30, 2013 10:47 AM
    Wednesday, January 30, 2013 4:53 AM
    Moderator

All replies

  • Hi,

    you should define two schema's: one for the header and one for the body. Then you can define a custom pipeline with a flat file assembler/disassmebler (depending if you are receiving or sending) and specify the header schema and body schema. for a good example of receiving flatfiles with a header (and trailer) see: 

    http://msdn.microsoft.com/en-US/library/aa560774(BTS.70).aspx

    Tuesday, January 29, 2013 9:37 PM
  • Do refer to this thread for help.


    Please mark the post answered your question as answer, and mark other helpful posts as helpful, it'll help other users who are visiting your thread for the similar problem, Regards -Rohit Sharma (http://rohitt-sharma.blogspot.com/)

    • Marked as answer by Akaschmid Wednesday, January 30, 2013 10:47 AM
    Wednesday, January 30, 2013 4:53 AM
    Moderator