Home Forums SQL Server 2012 SQL Server 2012 - T-SQL BCP through XP_CMDSHELL not responding RE: BCP through XP_CMDSHELL not responding

  • October 9, 2013 at 5:08 pm

    #1657342

    diegoanckizes (10/9/2013)

    That thing:

    EXEC('EXEC MASTER..XP_CMDSHELL ''BCP "SELECT * FROM [[db]]..[table]" QUERYOUT "C:\Users\processos\teste\TESTE.TXT" -t; -r -c -CRAW -U[user] -P[[pass]]''')

    TY

    You dont' need the double EXEC and you don't need the doubled-up brackets.

    EXEC MASTER..XP_CMDSHELL 'BCP "SELECT * FROM [db]..

    " QUERYOUT "C:\Users\processos\teste\TESTE.TXT" -t; -r -c -CRAW -Uuser -Ppass'

    It's also a very bad idea to use explicit user names and passwords. You should be using a trusted connection to that such things aren't in clear text.

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