In the SSIS data flow task, there is an XML Source component which allows you to specify your source XML file and optional XSD schema. From there you can pipe the data into a SQL Server destination.
hth,
Tim
Tim Mitchell, Microsoft Data Platform MVP
Data Warehouse and ETL Consultant
TimMitchell.net | @Tim_Mitchell | Tyleris.com
ETL Best Practices