本地数据库数据,导出到远程服务器问题
EXEC master..xp_cmdshell 'bcp "select * from smsdatav6..cmppcancelorder" queryout d:\baobiao\i.txt -c -t "|" -Skanerain -Usa -P2599'
这样导出到本机的D:\baobiao\i.txt 没问题
现在想导出到远程服务器
EXEC master..xp_cmdshell 'bcp "select * from smsdatav6..cmppcancelorder" queryout \\192.168.121.43\d\baobiao\i.txt -c -t "|" -Skanerain -Usa -P2599'
---------------------------------------------
报错如下
SQLState = S1000, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]无法打开 BCP 主数据文件
NULL
麻烦给帮帮忙