Actually, this seems to get me where I need to go. For some reason the tutorial I watched had @ signs in alias paths(?). When I took them out, it came back correct.

DECLARE @x xml

SELECT @x = P

FROM OPENROWSET (BULK '\\usd\SurveyComputing\Sample\SampleRepository\Visit_Survey_2013_08_16_07_21_43_edit.XML', SINGLE_BLOB) AS FMG(P)

--select @x

DECLARE @hdoc int

EXEC sp_xml_preparedocument @hdoc OUTPUT, @x

select *

from OPENXML (@hdoc, 'SURVEY_EXTRACT/VISIT_SURVEY/SURVEY_CNTCTS/SURVEY_CNTCTS_ROLE', 2)

WITH (SURVEY_ID int '../../SURVEY_ID',

SURVEY_TYPE nvarchar(128) '../../SURVEY_TYPE',

ENGLOC_ID int '../../ENGLOC_ID',

INDEX_NUM nvarchar(128) '../../INDEX_NUM',

RECORD_NUM nvarchar(128) '../../RECORD_NUM',

FM_AFM nvarchar(128) '../../FM_AFM',

FINAL_CONFERENCE_DATE datetime '../../FINAL_CONFERENCE_DATE',

VISIT_TYPE nvarchar(128) '../../VISIT_TYPE',

SERVICE_TYPE nvarchar(128) '../../SERVICE_TYPE',

LANGUAGE nvarchar(128) '../../LANGUAGE',

LOCATION_ADDRESS_1 nvarchar(128) '../../LOCATION_ADDRESS_1',

LOCATION_ADDRESS_2 nvarchar(128) '../../LOCATION_ADDRESS_2',

LOCATION_CITY nvarchar(128) '../../LOCATION_CITY',

LOCATION_STATE_PROVINCE nvarchar(128) '../../LOCATION_STATE_PROVINCE',

LOCATION_POSTAL_CODE nvarchar(128) '../../LOCATION_POSTAL_CODE',

LOCATION_COUNTRY nvarchar(128) '../../LOCATION_COUNTRY',

ACCOUNT_NUM nvarchar(128) '../../ACCOUNT_NUM',

ACCOUNT_NAME nvarchar(128) '../../ACCOUNT_NAME',

AE_INSURANCE_OFFICE nvarchar(128) '../../AE_INSURANCE_OFFICE',

FE_SERVICING_OFFICE nvarchar(128) '../../FE_SERVICING_OFFICE',

AE_NAME nvarchar(128) '../../AE_NAME',

AE_EMAIL nvarchar(128) '../../AE_EMAIL',

FE_NAME nvarchar(128) '../../FE_NAME',

VISIT_SURVEY_DATE nvarchar(128) '../../VISIT_SURVEY_DATE',

SURVEY_CNTCTS nvarchar(128) '../SURVEY_CNTCTS',

SURVEY_CONTACT_ID int '../SURVEY_CONTACT_ID',

FIRST_NAME nvarchar(128) '../FIRST_NAME',

LAST_NAME nvarchar(128) '../LAST_NAME',

MIDDLE_INITIAL nvarchar(128) '../MIDDLE_INITIAL',

PREFIX nvarchar(128) '../PREFIX',

SUFFIX nvarchar(128) '../SUFFIX',

PROFESSIONAL_TITLE nvarchar(128) '../PROFESSIONAL_TITLE',

EMAIL nvarchar(128) '../EMAIL',

PHONE nvarchar(128) '../PHONE',

SURVEY_CNTCTS_ROLE nvarchar(128),

SURVEY_CONTACT_ROLE_ID nvarchar(128),

SURVEY_CONTACT_ROLE nvarchar(128),

VISIT_SURVEY nvarchar(128),

SURVEY_EXTRACT nvarchar(128)

)

exec sp_xml_removedocument @hdoc