Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT @v_cmd = 'bcp "select rtrim(ltrim(record_ff)) '+
- 'from ##tmp_bcp_ff_salida_bl order by num_linea asc" queryout '+ @path_carga +''+@name+
- ' -c -C ACP -t \t -r \n '+
- '-S'+ @servidor + ' /T'
- print @v_cmd
- EXECUTE @RESULT = master..xp_cmdshell @v_cmd
- ------------------- Crea Archivos en Zona de backup-------------
- SELECT @v_cmd = 'bcp "select rtrim(ltrim(record_ff)) '+
- 'from ##tmp_bcp_ff_salida_bl order by num_linea asc" queryout '+ @path_carga_BK +''+@name+
- ' -c -C ACP -t \t -r \n '+
- '-S'+ @servidor + ' /T'
- print @v_cmd
- EXECUTE @RESULT = master..xp_cmdshell @v_cmd
Add Comment
Please, Sign In to add comment