I have succesfully loaded a copy of an xml file, which I stored in the same location of the SQL Server, into a SQL table using the following commands:
DECLARE @XML XML
SELECT @XML = X FROM OPENROWSET(BULK *path*, SINGLE_BLOB) AS XMLData(X)
However, the original location of this xml file is on another server and SQL does not accept the path of the original location. Is there a way to directly pull the xml file into SQL from the original remote location?