USE [DATA_SII]
IF (EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES  WHERE TABLE_NAME = '#empresas'))
BEGIN
DROP TABLE #empresas
CREATE TABLE #empresas
(
    rut int PRIMARY KEY,
    dv char(1),
    RazonSocial char(256),
    NumRes int,
    FechRes date,
    mailIntercambio char(256),
    url char(256)
)
END
GO
BULK INSERT #empresas
FROM 'c:\empresas.csv'
WITH
(
    FIRSTROW = 2,
    FIELDTERMINATOR = ';',  --CSV field delimiter
    ROWTERMINATOR = '\n'   --Use to shift the control to next row
)
GO
UPDATE
    RECEPTORES
SET
    Receptor_numRes = e.NumRes,
    Receptor_fechResol = e.FechRes,
    Receptor_mailIntercambio = e.mailIntercambio,
    Receptor_url = e.url,
    Receptor_electronico = 1
FROM
    RECEPTORES
INNER JOIN
    #empresas AS e
ON
    Receptor_rut = e.rut
GO
INSERT RECEPTORES(Receptor_rut,Receptor_dv,Receptor_razonSocial,Receptor_numRes,Receptor_fechResol,Receptor_url,Receptor_electronico)
(SELECT DISTINCT #empresas.rut,#empresas.dv,#empresas.RazonSocial,#empresas.NumRes,#empresas.FechRes,#empresas.url,1
FROM #empresas
LEFT JOIN RECEPTORES
ON (#empresas.rut = RECEPTORES.Receptor_rut)
WHERE RECEPTORES.Receptor_rut IS NULL)