Post reply

BCP w/UNC path

  • January 5, 2011 at 9:37 am

    #245018

    Hi all,

    I'm trying to output a file from one server to another using BCP.

    It fails, I think, because the path contains space in 'Program Files'. I also tried naming the path as 'Progra~1', but this didn't work either.

    Does anyone know how to resolve this?

    select @sqloutput = 'bcp test.dbo.test_con out "\\10.10.10.10\c$\Program Files\concentrasftp\concentra.txt" -c -t "|" -T -S'

    Thanks for your help.

  • January 5, 2011 at 10:54 am

    #1269650

    kevin_fralick (1/5/2011)

    Hi all,

    I'm trying to output a file from one server to another using BCP.

    It fails, I think, because the path contains space in 'Program Files'. I also tried naming the path as 'Progra~1', but this didn't work either.

    Does anyone know how to resolve this?

    select @sqloutput = 'bcp test.dbo.test_con out "\\10.10.10.10\c$\Program Files\concentrasftp\concentra.txt" -c -t "|" -T -S'

    Thanks for your help.

    What is the exact error that you get? Normally, when you enclose the file path with "" the spaces should be no problem. Maybe try another folder on that network location without spaces to be sure.

    Just to be sure, does the SQL Server service account has permissions to that folder?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • January 6, 2011 at 3:53 am

    This was removed by the editor as SPAM

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

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