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...