Refer Source: Load XML Files into SQL Server Tables - SSIS

XML Source:->

XSD Location:c:\output.\output.xsd

press button->Generate XSD

i.Use Data Conversion - for converting from unicode to nonunicode

ii.Consume the Dept & then the Employee separately. - specifying two different OLEDB destinations.

note:

i.download xsd.exe from internet & run any valid .xml file.

click on xsd.exe

xsd.exe test.xml

Open in Visual Studio 2008:Show the join diagram

modify: the joins, Set Primary Key

Exploring