Home Forums SQL Server 2005 SQL Server 2005 Integration Services Fixed width text file and SSIS RE: Fixed width text file and SSIS

  • September 8, 2008 at 7:18 pm

    #868812

    keywestfl9 (9/8/2008)

    TYPE PFORM TNAME LOGONID NAME NUM

    aaaaY Nsdffgg testb 14433333

    bbbbRCH0C tesgggd testb 13343434

    sample of the text file and there are many more columns

    value of each column starts exactly the same position as the header. but in this posting it gets shifted little bit here and there.

    Doesn't help me help you... whole row not displayed and was looking forward to you attaching one of the files. I'd also need the Create table statement to really help.

    The suggestion immediately above this post would also work.

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