BCP to txt file

25 Aug 2005 6:12 PM

Lontae Jones

I am trying the following but it only works on a local database I want to run
this on a remote server and have the file sent to my PC.

EXEC master..xp_cmdshell
'bcp "SELECT * FROM TestDB_data..titles" queryout "c:\test_08-25-05.txt" -S
server1 -U sa -P sapwd -c'

25 Aug 2005 6:21 PM

Alejandro Mesa

You have to create a shared folder in your pc and give write access to sql
agent services account. Then use that shared folder in the bcp command.

EXEC master..xp_cmdshell
'bcp "SELECT * FROM TestDB_data..titles" queryout
"\\your_pc_name\shared_folder\test_08-25-05.txt" -S
server1 -U sa -P sapwd -c'

AMB

Show quote

"Lontae Jones" wrote:

> I am trying the following but it only works on a local database I want to run
> this on a remote server and have the file sent to my PC.
>
> EXEC master..xp_cmdshell
> 'bcp "SELECT * FROM TestDB_data..titles" queryout "c:\test_08-25-05.txt" -S
> server1 -U sa -P sapwd -c'
>

25 Aug 2005 6:22 PM

B.M

It works only if your servers are linked.

Try using tabe name directly (instead of using query) it should work

bcp "TestDB_data..titles" OUT c:\test_08-25-05.txt .....

Show quote

"Lontae Jones" <LontaeJo***@discussions.microsoft.com> wrote in message
news:80C1C9DA-2C3F-4048-9B55-7F849FD6B662@microsoft.com...
>I am trying the following but it only works on a local database I want to
>run
> this on a remote server and have the file sent to my PC.
>
> EXEC master..xp_cmdshell
> 'bcp "SELECT * FROM TestDB_data..titles" queryout
> "c:\test_08-25-05.txt" -S
> server1 -U sa -P sapwd -c'
>