Hi

Please can someone help....

I am trying to extract bcp files from a folder, however its not working:

C:\bcp Juliansql.dbo.extract_acct_submit out C:\bcpexport\extra
ct_acct-Submit.txt -T -c

What am I doing wrong?

Help please.........

Thanks



• Edited by Sharon1001 15 hours 49 minutes ago

1.Try to find out where the bcp.exe installed.

    Start--->search bcp ----> get the bcp installed location(right click on bcp will get path where the bcp installed)

2.click Start--->in search window type  CMD -->enter----> change the directory to bcp installaed location.

   example: E:\sqlserver\sql\bcp.exe  ( then change directory to "E:\sqlserver\sql")

cd E:\sqlserver\sql  (hit enter)  then run below command.

bcp [DB_Name].[dbo].[Table_Name] out "C:\Tmp\BCP_out.txt" -T -c

thanks

Hi Arthur

The error received is: 

Use UDL to check connectivity and ultimately its connection string to connect as

bcp Juliansql.dbo.extract_acct_submit out C:\bcpexport\extra

ct_acct-Submit.txt -T -c -U<login_id> -P<password> -S<server_name\instance_name>

Hi,

You forgot to specify the SQL server instance as -S servername\instancename

If you don't specify it, bcp will connect to default instance on your own PC.