Thanks, we don't have time to build drivers right now...

We have both 32 and 64 bit installed on desktop. Only 64 bit on server. Runs locally, not on...

I'm trying to do use the SP on a Standard Edition 2005 SQL Server that can't be upgraded to 2008 R2 yet. You can't set the run in 32...

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