title: How to import an XML file into SQL Server 2012
body: <p>I have an XML file that I want to import into <code>SQL Server 2012</code>. I haven't done it before and I don't know a lot. After some research, I tried to open the xml file with the following command that was run in SQL Server Management Studio.  </p>
  
  <pre><code>SELECT CAST(x as XML) FROM OPENROWSET(
  BULK 'C:\bulk\Users_test1111.xml',
  SINGLE_BLOB
  ) AS X  
  </code></pre>
  
  <p>For this I get the following error:  </p>
  
  <pre><code>Msg 4861, Level 16, State 1, Line 1
  Cannot bulk load because the file "C:\bulk\Users_test1111.xml" could not be opened. Operating system error code 3(The system cannot find the path specified.).
  </code></pre>
  
  <p>What do you suggest to do to get the file into the database?</p>