Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Jacob Sebastian XML Workshop XII - Parsing a delimited string RE: XML Workshop XII - Parsing a delimited string

  • December 5, 2007 at 6:09 am

    #757305

    Right in the middle of the million rows is a record or two that is mangled. Rejecting the file isn't an option. The import routine needs to be able to import all the good stuff and leave the bad stuff in a 'limbo' file for manual intervention.

    BCP will do just that very nicely... second in speed only to Bulk Insert which does not have such a capability.

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