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 2:15 pm

    #1458836

    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.

    Nice, good call.

    _________________________________
    seth delconte
    http://sqlkeys.com