Home Forums SQL Server 7,2000 Administration DTS Issues RE: DTS Issues

  • March 26, 2008 at 7:54 am

    #794030

    One way to find the bad row is to import it into a two column table (1 for a row num, the other for the data). You know how many quotes there should be for all the rows... if you do something like the following, it may find the row...

    SELECT RowNum, TheData

    FROM yourtemptable

    WHERE LEN(TheData) <> LEN(REPLACE(TheData,'"',''))

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