I have one xml file in some share network drive which I want to load.
I can load the XML file into XML Source. But Can I save that XML data into some XML variable that I can pass into a stored procedure? if Yes How Can I save the XML into a XML variable in SSIS.
If the above is not possible, I was thinking to pass the XML File path to the stored procedure and from with in the SP I will use "SELECT * FROM OPEROWSET (BULK..." to load the XML into variable and process.
Please advice which method I should opt here if I look into performance and multiuser case?
View Complete Post