How to avoid duplicates records while bulk inserting in to table using openxml in SQL?

See more:

C#

ASP.NET

SQL

I want to avoid duplicates records while bulk inserting in to Table in SQL. I am passing XML as input parameter and inserting using OpenXml

What I have tried:

EXEC sp_xml_preparedocument @docHandle OUTPUT, @ip_XML                 
BEGIN TRY               
BEGIN TRAN                     
SET @op_error_code = 0;              

IF(@ip_Status ='I')            
BEGIN            

	INSERT INTO ACH_OUTWARD_Files                
	(   
	            
	FileName                 
	, FileType                 
	, Status                 
	, CreatedDate              
	   
	)           
	 
	SELECT indx.FileName                 
	, '102_OUTWARD_ACH'                 
	,  indx.Mode              
	, GETDATE()                 
 
	FROM OPENXML(@docHandle, '/WPS/MDL_ACH_Outward_Details',2)WITH                                  
	(   
	FileName varchar(100)  
	,FileType varchar(50)                 
	, Mode  varchar(1)    
	, CreatedDate DateTime             
	) 

EXEC sp_xml_removedocument @docHandle   

END