Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Bulk extract data from table to a remote path

Author  Topic 

gmsonline4u
Starting Member

1 Post

Posted - 2007-01-08 : 07:49:04
How to extract data from table to a remote(shared) path rather than to the database server path?

I tried with the following command :

bcp "select * from tblemp" queryout "\\server\folder\test.txt" -c -t , -S "DBserver -o "1.TXT" -U "Sa" -P "password"

and get the error msg as

bcp: Unable to open output file \\server\folder\test.txt: Permission denied.
   

- Advertisement -