Akhil Madivada

Akhil Madivada

  • NA
  • 58
  • 7k

Creating SSIS package for XML file for required data in Data

May 26 2017 1:36 AM
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?