• Is there a way to break it up? If not maybe doing the import out of SQL, such as using a .NET app or something to do the import.

    that's a HUGE XML file. The largest XML file I ever imported was 8 gb, and I created an .NET app do to the importing into the SQL database