title: how to read the content of xml file in the remote(network) machine through mssql stored procedures
body: <p>I tried to read the contents of single xml file in the local machine  using bulk insert.</p>
  
  <pre><code>SELECT * FROM OPENROWSET ( BULK '''+ @FILENAME+''' , SINGLE_CLOB ) AS xmlData
  </code></pre>
  
  <p>It is working, but the same i am trying to read from the remote machine. its giving the following error</p>
  
  <pre><code>Msg 4861, Level 16, State 1, Line 1
  Cannot bulk load because the file "Z:\TechnicalLoss_EnergyAccounting_10.10.2012.12.19.PM.XML" could not be opened. Operating system error code 3(The system cannot find the path specified.).
  </code></pre>
  
  <p>i given the filepath as </p>
  
  <pre><code>\\172.16.11.52\D:\TechnicalLoss_EnergyAccounting_10.10.2012.12.19.PM.XML
  </code></pre>
  
  <p>It gives the same error then, I created the network share drive for that remote machine that is (z:) given the filepath as</p>
  
  <pre><code>Z:\TechnicalLoss_EnergyAccounting_10.10.2012.12.19.PM.XML
  </code></pre>
  
  <p>same error :-( Help me to resolve it? </p>