http://blog.hoegaerden.be/2011/04/07/loading-xml-using-ssis/

I recomend this to you and follow step by step as explained and it is that easy.

Looks like there is an error processing the xml at this line

<PreferredName>KERRVILLE...

USE Database_name

GO

SP_SPACEUSED 'yourschema.yourtablename'

GO

The above gives the number of rows and other information regarding the table. This is the faster way to see the number of commited rows in a table.