No repetir dato en carga con BULK

[Libras]

Código SQL:

INSERT INTO tabla
  (campos)
 
SELECT * FROM(
SELECT 
    SELECT campos, ROW_NUMBER() OVER partition(BY campo no repetido ORDER BY campo no repetido) AS rn
      FROM  OPENROWSET(BULK  ''D:\folder\filename."'',--File that are procesed
      FORMATFILE='test.Xml',--Format file, that file contains the info of the columns that are used in the fill of the table        
      FIRSTROW = 2 --Row where the info start
       ) as t1 
) t2 where rn=1
 

Saludos!