This seemed to have worked:

EXEC('

INSERT INTO mapData_center(sourceXML)

SELECT *

FROM OPENROWSET(BULK ''C:\parcels_poly_center.xml'', SINGLE_CLOB) AS X'

)

Thanks for all the help.

If I'm logged into SQL Server Management Studio using Windows Authentication, shouldn't SQL Server use my account?

In order to make sure I wasn't making a typo I pretty much copied and pasted your code:

DECLARE @FileName VARCHAR(500)

SET @FileName = 'C:\parcels_poly_center.xml'

CREATE TABLE #XmlImport

...

Thanks for the reply. I've been trying this approach, but it seems like each way I try, it says the xml file does no exist when I have the...