Post reply

SQL Job and bcp

  • December 23, 2010 at 9:49 am

    #231014

    I have a SQL Job that executes a bcp statement when submitted as a t-sql,

    EXEC master..xp_cmdshell @output where @output is a string that holds the bcp statement.

    However, the same bcp statement does not work when run as a operating system command.

    Any guidance is greatly appreciated.

    +ive

  • December 30, 2010 at 9:39 am

    #1267758

    What is the error message that you receive?

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

  • December 30, 2010 at 11:10 am

    #1267827

    Error Message:

    (reason: The system cannot find the file specified). The step failed.

    I changed the destination of the output file to a network h:\ drive instead of the c:\ and it worked.

    Thanks for checking.

    +ive

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply