In the database table I have columns TimeStamp column, Meterdirection column, MeterName 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 can anyone help me?
What I did: created a package inSSIS to Extract the XML file using the XML source and for the Load OLEDB Destination and in transformation I used the Derived column to get required column but in the destination table, MeterDataId and MeterName are not populating.