este codigo......................
DECLARE @Cmd varchar(800)
DECLARE @ServerName varchar(100)
DECLARE @DatabaseName varchar(100)
DECLARE @SQL varchar(800)
DECLARE @OutputFile varchar(1000)
SET @ServerName = 'sirdevsp1'
SET @DatabaseName = 'sip_db'
SET @SQL = '"SELECT * FROM user_juanchor.tbl_sp_productFamily_sid"'
SET @OutputFile = '\\sirdevsp1\d$\SteelPlanner-Proto-Sidor\FilesMFC\11pm\productfamilies'+convert(char(8), getdate(), 112)+'.txt'
SELECT @Cmd = 'bcp '+@SQL+' queryout '+ @OutputFile + ' -c -S'+@ServerName+' -Uuser_juanchor -Pjuanchor2r'
print @Cmd
EXEC master..xp_cmdshell @Cmd
...................me da este error
bcp "SELECT * FROM user_juanchor.tbl_sp_productFamily_sid" queryout \\sirdevsp1\d$\SteelPlanner-Proto-Sidor\FilesMFC\11pm\productfamilies20041005.txt -c -Ssirdevsp1 -Uuser_juanchor -Pjuanchor2
Msg 50001, Level 1, State 50001
xpsql.cpp: Error 87 from GetProxyAccount on line 604.