Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Unable to copy data to remote machine through BCP!! Expand / Collapse
Author
Message
Posted Wednesday, August 8, 2012 4:38 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Yesterday @ 6:36 AM
Points: 1, Visits: 57
hi folks,
i am trying to copy data to remote server through BCP.

I am getting the error while executing the query "Error = [Microsoft][SQL Server Native Client 10.0]Unable to open BCP host data-file"

xp_cmdshell 'bcp " select * from DBNAME.._MyTempTable" queryout "\\Machinename\M$\MyData\Outbound\Inbound_08082012.csv" -c -t"," -r"" -S SqlServer -T '

when i am running the query without \\Machinename its working fine that means its not working with the remote machine.

The command is running when i am executing it from cmd prompt but xp_cmdshell is giving error.

I have checked the login under which sql server is running and the machine credentials both are same.
user is having the write permission to the folder too..

any help will be highly appreciated.


Thanks
Arnab
Post #1341778
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse