It's easy without SSIS. Here's a demo

--make the table you need

CREATE TABLE XmlImportTesting(

xmlFileName VARCHAR(300) NOT NULL,

xml_data XML NOT NULL

)

GO

DECLARE @xmlFileName VARCHAR(300)

SELECT @xmlFileName = '\\aitl-testsql1\e$\EProfTestXML\Item3.txt'

-- dynamic sql is just so we can use @xmlFileName variable in OPENROWSET

EXEC('INSERT INTO XmlImportTesting(xmlFileName,xml_data)

SELECT ''' + @xmlFileName + ''', xmlData

FROM (

SELECT *

FROM OPENROWSET (BULK ''' + @xmlFileName + ''' , SINGLE_BLOB) AS XMLDATA

) AS FileImport (XMLDATA)

')

GO

SELECT * FROM XmlImportTesting

DROP TABLE XmlImportTesting