What is the best way to import data from XML file into a single XML column in a database? (The whole XML from the file)?
I'd like to use SSIS and I already tried BULK LOAD from OPENROWSET and got an error about file not existing,
Need a different approach. Current way is using script task (in VB.NET) to write content into memory variable and then insert using that variable.
Thanks in advance.