We get an XML file that I have to parse and store in a database. The values are coming in as a Name-Value pair instead of regular XML. I do not want to store it as a name-value pair. The Start-Time and Stop-Time can be ignored (they repeat). I would rather build columns like CREDIT_RATING, UNIT_ARR_CREDIT_RATE, UNIT_CAP_CHRG_ATC_KWH, T01_UNIT_FIXED_ENRGY_COST_ATC to hold the values. How do I go about building an XSD to use in SSIS for this?
I am (happily?) rubbish at XML so you may get a proper answer from someone else in due course but have you tried using SSIS or LogParser to handle the import? SSIS allows you the option to generate an XSD from the source file. LogParser may not need one.