Home Forums SQL Server 7,2000 Administration getting error "The system cannot find the path specified." using xp_cmdshell RE: getting error "The system cannot find the path specified." using xp_cmdshell

  • I am having a similar issue:

    EXEC master..xp_cmdshell

    "dir \\fserver1\NextgenRoot\Prod\EMR\Images\ImageSaved\84C06D96-D350-47ED-B26D-BF1A794D93A6.pdf"

    Results:

    Volume in drive \\fserver1\NextgenRoot is Data

    Volume Serial Number is 3CEC-F907

    NULL

    Directory of \\fserver1\NextgenRoot\Prod\EMR\Images\ImageSaved

    NULL

    09/28/2014 01:29 PM 413,455 84C06D96-D350-47ED-B26D-BF1A794D93A6.pdf

    1 File(s) 413,455 bytes

    0 Dir(s) 15,483,371,520 bytes free

    NULL

    But when I try to move that file:

    EXEC master..xp_cmdshell

    'MOVE "\\fserver1\NextgenRoot\Prod\EMR\Images\ImageSaved\C06D96-D350-47ED-B26D-BF1A794D93A6.pdf" "\\fserver1\NextgenRoot\IHS_DocsImagesToBeRemoved\C06D96-D350-47ED-B26D-BF1A794D93A6.pdf"'

    Results are:

    The system cannot find the file specified.

    Clearly the file is there but the move command cannot find it. What am I missing?