Guest User

Untitled

a guest
Apr 21st, 2018
66
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.66 KB | None | 0 0
  1.   SELECT @v_cmd = 'bcp "select rtrim(ltrim(record_ff)) '+
  2.         'from ##tmp_bcp_ff_salida_bl order by num_linea asc"  queryout '+ @path_carga +''+@name+
  3.                 ' -c -C ACP -t \t -r \n '+
  4.                 '-S'+ @servidor + ' /T'
  5.  
  6.   print @v_cmd
  7.   EXECUTE @RESULT = master..xp_cmdshell @v_cmd
  8.  
  9. ------------------- Crea Archivos en Zona de backup-------------
  10.  
  11.   SELECT @v_cmd = 'bcp "select rtrim(ltrim(record_ff)) '+
  12.         'from ##tmp_bcp_ff_salida_bl order by num_linea asc"  queryout '+ @path_carga_BK +''+@name+
  13.                 ' -c -C ACP -t \t -r \n '+
  14.                 '-S'+ @servidor + ' /T'
  15.  
  16.   print @v_cmd
  17.   EXECUTE @RESULT = master..xp_cmdshell @v_cmd
Add Comment
Please, Sign In to add comment