Loading XML data into SQL Server 2008
7) Once the package has successfully executed you can see the tasks turning green and it will also mention the number of records transformed and published to SQL Server.
8) The sample XML data file used in this example is shown in the following image:
9) The data which was loaded into the SQL Server Table by the SSIS package is shown below:
10) Save the SSIS package by pressing CTRL + S