Import xml data into existing SQL Table using c#

We will have some XML documents saved in a shared folder and I need to import them as insert/update into an existing SQL Server table that contains the correct XML document tags.

I would like for my desktop app to load a document, import as insert or update if it already exists and then upon success delete that document from the folder and go to the next one.

Can anyone show me some examples that I might be able to work with?

This is what I have tried so far, however I get errors that the PalletID is not part of the datasource.

SqlConnection con = new SqlConnection(MyGlobals.SQLConnStr()); 

DataSet reportData = new DataSet(); 
reportData.ReadXml("C:\Users\admin\Desktop\GitHub\*.xml"); 

SqlBulkCopy sbc = new SqlBulkCopy(con); 
sbc.DestinationTableName = "PalletSpecs"; 
sbc.ColumnMappings.Add("PalletId", "PalletSpecs.PalletID");            
sbc.ColumnMappings.Add("_PalletLength", "_PalletLength"); 
sbc.ColumnMappings.Add("_PalletWidth", "_PalletWidth"); 
sbc.ColumnMappings.Add("_PalletClass", "_PalletClass"); 
sbc.ColumnMappings.Add("_PalletStyle", "_PalletStyle"); 
sbc.ColumnMappings.Add("_EntryStyle", "_EntryStyle"); 
sbc.ColumnMappings.Add("_Number", "_LumberNumber"); 
sbc.ColumnMappings.Add("_Style", "_Style"); 
sbc.ColumnMappings.Add("_Location", "_Location"); 
sbc.ColumnMappings.Add("_Type", "_Type"); 
sbc.ColumnMappings.Add("_Length", "_Length"); 
sbc.ColumnMappings.Add("_Width", "_Width"); 
sbc.ColumnMappings.Add("_Height", "_Height"); 
sbc.ColumnMappings.Add("_FasternerID", "_FasternerID"); 
sbc.ColumnMappings.Add("_FasternerType", "_FasternerType"); 
sbc.ColumnMappings.Add("_Number", "_Number"); 
sbc.ColumnMappings.Add("Note", "Note"); 

con.Open(); 
sbc.WriteToServer(reportData.Tables[0]); 
con.Close();

Here is an example of my xml file:

AACEAS1




Pine
Green





Pine

Can anyone help a newbie?