Home Forums SQL Server 7,2000 T-SQL BCP error -Unable to open BCP host data-file RE: BCP error -Unable to open BCP host data-file
Sergiy
SSC Guru
Points: 110206
More actions
June 18, 2010 at 5:06 pm
#1182384
When you run bcp on your local machine C:\ is your local drive.
When you run bcp on the server C:\ is a local drive on he server.
Compare:
"dir C:\" from command prompt and
exec master.dbo.xp_cmdshell 'dir c:\'
_____________Code for TallyGenerator