asked
bulk with variable
I've got this Procedure: it runs well, but when i want to get the xml-File in the Bulk as a variable i don't get it run... and I don't know how I can solve this with an EXEC??? Any ideas?? Thanks! Steppe DECLARE @docHandle int DECLARE @xmlDocument xml -- or xml type SET @xmlDocument =(SELECT * FROM OPENROWSET( BULK 'C:\Users\WST\Desktop\Job_Revit\Import\ATPSheet1.xml', SINGLE_BLOB) AS x) EXEC sp_xml_preparedocument @docHandle OUTPUT, @xmlDocument -- Use OPENXML to provide rowset consisting of customer data. INSERT PLA_ELEMENT SELECT * FROM OPENXML(@docHandle, '/FILE_EXPORT/PLA_ELEMENT',2) WITH PLA_ELEMENT --Use OPENXML to provide rowset consisting of order data. EXEC sp_xml_removedocument @docHandle
