bcp远程导出数据

-- =============================================
-- Author:  <Author,,Name>
-- Create date: <Create Date,,>
-- Description: <Description,,>
-- =============================================
ALTER PROCEDURE [dbo].[proc_jsmx_out_temp]
@sql varchar(5000),
@filepath varchar(500),
@msg varchar(5000) output
AS
BEGIN
 -- SET NOCOUNT ON added to prevent extra result sets from
 -- interfering with SELECT statements.
 SET NOCOUNT ON;
    declare @bcp varchar(3000)
    set @bcp =  'bcp "'+@sql+'" queryout  '+@filepath+ '   -c  -S"127.0.0.1"   -U"sa"   -P"密码"'
    begin tran
    begin try
    exec master..xp_cmdshell'net use //xx.xx.xx.xx/d$/website_new_0111/cwdetai "密码" /user:xx.xx.xx.xx/用户名'
--    exec  master..xp_cmdshell 'dir //xx.xx.xx.xx/d$/website_new_0111/cwdetai 
    exec master..xp_cmdshell @bcp
 --   set @msg=@bcp
    commit
    end try
    begin catch
    rollback
--    set @msg='系统忙，请重新导出'
    set @msg=ERROR_MESSAGE()
    end catch
END