Post reply

bcp help - Direct Output file to a different Server??

  • March 3, 2005 at 3:44 pm

    #76254

    Hi,

    I'm using NT authentication. I run the following from server1. I would like to have the output placed on server2, but the file keeps getting directed to server1. Any thoughts?

    C:\>bcp "Northwind.dbo.Region" out "c:\temp\zz_region3.txt" -Sserver2 -c -T

    Starting copy...

    4 rows copied.

    Network packet size (bytes): 4096

    Clock Time (ms.): total       10

     

     

    Many thanks. Jeff

  • March 3, 2005 at 4:00 pm

    #545355

    Try using a UNC path to Server2. Instead of "c:\temp\zz_region3.txt"

    try \\Server2\c$\temp\zz_region3.txt

    Kindest Regards,

  • March 3, 2005 at 4:00 pm

    #545354

    Try with a UNC and shared folder ?

    C:\>bcp "Northwind.dbo.Region" out "\\Server2\ShareName\zz_region3.txt" -Sserver2 -c -T

     

  • March 4, 2005 at 8:13 am

    #545482

    Excellent. It works!

    Many thanks. Jeff

Viewing 4 posts - 1 through 4 (of 4 total)

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