Home Forums SQL Server 2005 Business Intelligence Processing flat file with Header,Detail and Trailer RE: Processing flat file with Header,Detail and Trailer

  • April 5, 2014 at 11:04 am

    #1703505

    naresh0407 (4/4/2014)

    Hi All,

    I have below flatfile.Please let me know how to process this file without scripttask in SSIS.

    I need to split header into 1 file or db,detail into another file and trailer into another filee.

    I have tried with condition split its not working.

    H,2011-06-02

    D,value1,value2,value3,1

    D,value1,value2,value3,2

    D,value1,value2,value3,3

    D,value1,value2,value3,4

    T,4, 10

    Thanks in Advance

    Do you mean that you actually need to create 3 DISK files from that one file? Or are you trying to put the data into 3 different tables?

    Also, are you actually trying to do this in SSIS and just trying to avoid the script task or are you trying to avoid SSIS altogether?

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)