How to load xml file with multiple outputs in SSIS?

• Sam332

  SSC Enthusiast

  Points: 174

  More actions

  July 30, 2020 at 9:31 pm

  #3776138

  have 6 XML files that contain the same columns for different students, when I add XML Source and link it then generate the xsd, and then when I go to mapping I see 4 output names and each output name got different columns. for example Output name: Students col1, col2, col3, and the other output

  output name: Class col3, col4, col5

  output name: Section col6, col7, col8

  I need to get separate columns from each output above to OLEDB destination so my destination will have col1, col4,col5, col7, col8

  How can I achieve that?

• Phil Parkin

  SSC Guru

  Points: 247158

  More actions

  July 30, 2020 at 11:45 pm

  #3776168

  Can you provide sample (sanitised) XML for one single student's data?

  ---