SQL_PROC_IMPORT_FICHERO

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

*/