If no, please suggest an alternative way to do this.

Reformat the XML file to a delimited file and use BCP on that.