Home Forums SQL Server 2012 SQL 2012 - General SSIS Checking Header Row from a .csv file RE: SSIS Checking Header Row from a .csv file

  • March 6, 2015 at 2:54 pm

    #1782302

    ericwenger1 (3/5/2015)

    I need to be able to see if the incoming csv file had a head row different than the previous files header row. That will tell me that I have new columns.

    The easiest thing to do would be to just read the first row as one large blob and save it. When the next file comes along, read the header as a blob and do a direct comparison to what you've saved using either "=" or "<>". That will certainly tell you if there's been a change.

    If you need to isolate the column names as rows, read the header row and split it.

    --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)