Home Forums SQL Server 2005 SQL Server 2005 Strategies Parsing tab selimited text into SQL table RE: Parsing tab selimited text into SQL table

  • March 13, 2012 at 5:53 pm

    #1458944

    opc.three (3/13/2012)

    If you use SQL Agent, there is no need to introduce an additional programming domain into the call stack. Ditch xp_CmdShell and call bcp from a step with type CmdExec.

    SSIS would be an equally capable tool to use here as well.

    Ditch SSIS for an equally capable tool for this problem. Just use BULK INSERT and be done with 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)