Post reply

How to load xml file with multiple outputs in SSIS?

  • 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?

  • July 30, 2020 at 11:45 pm

    #3776168

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

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply