Home Forums SQL Server 2005 SQL Server 2005 General Discussion bcp error through xp_cmdshell RE: bcp error through xp_cmdshell

  • June 3, 2009 at 2:37 pm

    #1004293

    master..xp_cmdshell 'bcp ..out -U -P '

    i guess you need to read up on the syntax. If that is your real command, you are not specifying any of the required values;

    here's a working example:

    declare @sql varchar(4000),

    @rowcount int

    --sample query: you would do the same to your existing bcp

    set @sql = 'bcp "SELECT TOP 5 * FROM SYSOBJECTS" queryout "c:\body.txt" -c -U"sa" -P"NotARealPassword"'

    --export via bcp

    insert into #results

    EXEC master..xp_cmdshell @sql

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!