Creating SSIS package for XML file for required data in Data

Question

Developers, I am working on SSIS and I want to create a package to populate the XMLdata in the database from an XML source file and my source file sample data is here:

 

 

 

 

In the database table I have columns TimeStamp column and the Meterdirection column and I need the both values to populate in the columns of the table and there is one more table in available in the database with Meterdirection type with Delivered=1 and Received=2, So now how can I create the package in SSIS main tricky task is here I am not getting the MeterDirection column values, can anyone help me?