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.
| Author |
Topic |
|
vinay.a
Starting Member
20 Posts |
 Posted - 2009-02-04 : 07:36:21
|
hi,I am using the bcp utility to export contents of a table from sql server 2005 express DB into text file.When the destination of the file is the local system(where the sql server is present), it works fine.But when the destination of the file is the remote system, the bcp utility does not seem to be writing the table data.The following is the command that I am executing in the query analyser:exec testDB..xp_cmdshell 'bcp "Select * from testDB.dbo.customers" queryout "\\networkComp1\testFolder\customerData.csv" -c -t"|" -T -S myComp01' Please let me know if it needs any changes or any configurations.regards,vinay |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-04 : 09:54:10
|
| What is error you are getting? |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-02-04 : 10:06:49
|
| does account running bcp has access to folder \\networkComp1\testFolder ? |
|
|
|
|
|
|
bcp utility - not writing data to a remote system