Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DECLARE @l_Id INT --# ERROR O EXITO DE LA OPERACION
- DECLARE @l_Msje VARCHAR(1000) --# Mensaje de error o exito de la operacion
- DECLARE @l_Ruta VARCHAR(250) --#Ruta del directorio
- DECLARE @l_Trx_typ VARCHAR(32) --#Valor del campo TRX_TYP
- DECLARE @l_Sql_Cmd VARCHAR(1000) --#sentencia sql
- DECLARE @l_Sql_Shell VARCHAR(1000) --#setencia para la consola shell
- DECLARE @l_Nom_Arch VARCHAR(16) --#nombre del archivo
- BEGIN TRY
- SET @l_Ruta ='T:RemesasLiq_RemeBackup';
- SET @l_Sql_Cmd = '';
- SET @l_Sql_Shell = '';
- SET @l_Trx_typ = '';
- SET @l_Nom_Arch = 'TLOG';
- SELECT @l_Trx_typ = LTRIM(RTRIM(TRX_TYP)) FROM EXP_POSLOG WHERE ID = @p_ntra;
- IF (@l_Trx_typ = 'TenderOutflow')
- BEGIN
- SET @l_Nom_Arch = 'TLOG'+'_'+Cast(@p_ntra as varchar(10))+'.XML'
- SET @l_Sql_Cmd = 'SELECT POSLOG FROM EXP_POSLOG WHERE ID = '+ Cast(@p_ntra as varchar(10));
- Set @l_Sql_Shell = 'EXEC xp_cmdshell ' +char(39) +'bcp' +' "'+@l_Sql_Cmd+'"'+ ' QUERYOUT '+ '"'+@l_Ruta+@l_Nom_Arch+'"' +' -T -c -t"t"'+char(39);
- Execute (@l_Sql_Shell)
- END
- END TRY
- BEGIN CATCH
- SET @l_Id = ERROR_NUMBER()
- SET @l_Msje = ERROR_MESSAGE()
- SELECT @l_Id as 'id', @l_Msje as 'msje'
- END CATCH
- END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement