Pasted

CREATE PROCEDURE IMPORTAR_FICHERO
   @TABLA VARCHAR(100),@RUTA_FIC VARCHAR(500),@bBorrar BIT
AS
 
DECLARE @STR_SQL NVARCHAR(1000)
 
IF @bBorrar = 1
BEGIN
        SELECT @STR_SQL = 'TRUNCATE TABLE ' + @TABLA
        EXEC sp_executesql @STR_SQL
END
 
SELECT @STR_SQL = 'BULK INSERT ' + @TABLA + CHAR(10)
SELECT @STR_SQL = @STR_SQL + 'FROM ' + CHAR(39) + @RUTA_FIC + CHAR(39) + ' ' + CHAR(10)
SELECT @STR_SQL = @STR_SQL + 'WITH (ROWTERMINATOR =' + CHAR(39) + '\n'  + CHAR(39) + ','
SELECT @STR_SQL = @STR_SQL + 'FIRSTROW = 2,MAXERRORS = 0,CODEPAGE ='+ CHAR(39) + '1252' + CHAR(39) + ')'
 
EXEC sp_executesql @STR_SQL
--PRINT @STR_SQL
 
GO
 
 
 
/*
-- *********************************************************************************************
-- ************************************* LLAMADA ***********************************************
-- *********************************************************************************************
 
DECLARE @TABLA VARCHAR(100),@RUTA_FIC VARCHAR(500),@bBorrar BIT
SELECT @bBorrar = 1
SELECT @TABLA = 'A_tbODIN_Boletines_UG_IMPORT'
SELECT @RUTA_FIC = '\\Pandora\sime\CARGA_SIME\ODS\FICHEROS_ODS\TXT_Boletines_UG_2014-08-28.txt'
 
 
EXEC IMPORTAR_FICHERO @TABLA, @RUTA_FIC,@bBorrar
 
*/