title: Bulk Loading XML Into SQL Server 2012 using Visual Studio 2010
body: <p>I need to figure out how I can bulk load XML into Microsoft SQL Server 2012 using Visual Studio 2010. I have followed the instructions <a href="http://msdn.microsoft.com/en-us/library/ms171878.aspx" rel="nofollow">here</a>, but this gets me a long list of errors (included below).</p>
  
  <p>Additionally, I'm not entirely sure what I'm supposed to do with the instructions for #8: "Replace the Main() method with the following code. Update the ConnectionString property and the file path to the schema and data files." Can someone give me a quick rundown, please?</p>
  
  <p>Though I'm not sure it will help, I also added the SQL DB as a data source.</p>
  
  <p>Error   1:</p>
  
  <blockquote>
    <p>The type 'SQLXMLBULKLOADLib.SQLXMLBulkLoad4Class' has no constructors defined  C:\Users\coopere.COOPERE-PC\documents\visual studio 2010\Projects\Aztech - Bulk Load\Aztech - Bulk Load\Program.cs  15  64  Aztech - Bulk Load</p>
  </blockquote>
  
  <p>Error   2:</p>
  
  <blockquote>
    <p>'SQLXMLBULKLOADLib.SQLXMLBulkLoad4Class' does not contain a definition for 'ConnectionString' and no extension method 'ConnectionString' accepting a first argument of type 'SQLXMLBULKLOADLib.SQLXMLBulkLoad4Class' could be found (are you missing a using directive or an assembly reference?)  C:\Users\coopere.COOPERE-PC\documents\visual studio 2010\Projects\Aztech - Bulk Load\Aztech - Bulk Load\Program.cs  16  23  Aztech - Bulk Load</p>
  </blockquote>
  
  <p>Error 3:</p>
  
  <blockquote>
    <p>'SQLXMLBULKLOADLib.SQLXMLBulkLoad4Class' does not contain a definition for 'ErrorLogFile' and no extension method 'ErrorLogFile' accepting a first argument of type 'SQLXMLBULKLOADLib.SQLXMLBulkLoad4Class' could be found (are you missing a using directive or an assembly reference?)  C:\Users\coopere.COOPERE-PC\documents\visual studio 2010\Projects\Aztech - Bulk Load\Aztech - Bulk Load\Program.cs  17  23  Aztech - Bulk Load</p>
  </blockquote>
  
  <p>Error 4: </p>
  
  <blockquote>
    <p>'SQLXMLBULKLOADLib.SQLXMLBulkLoad4Class' does not contain a definition for 'KeepIdentity' and no extension method 'KeepIdentity' accepting a first argument of type 'SQLXMLBULKLOADLib.SQLXMLBulkLoad4Class' could be found (are you missing a using directive or an assembly reference?)  C:\Users\coopere.COOPERE-PC\documents\visual studio 2010\Projects\Aztech - Bulk Load\Aztech - Bulk Load\Program.cs  18  23  Aztech - Bulk Load</p>
  </blockquote>
  
  <p>Error 5:</p>
  
  <blockquote>
    <p>'SQLXMLBULKLOADLib.SQLXMLBulkLoad4Class' does not contain a definition for 'Execute' and no extension method 'Execute' accepting a first argument of type 'SQLXMLBULKLOADLib.SQLXMLBulkLoad4Class' could be found (are you missing a using directive or an assembly reference?)    C:\Users\coopere.COOPERE-PC\documents\visual studio 2010\Projects\Aztech - Bulk Load\Aztech - Bulk Load\Program.cs  19  23  Aztech - Bulk Load</p>
  </blockquote>
  
  <p>Error 6:</p>
  
  <blockquote>
    <p>Interop type 'SQLXMLBULKLOADLib.SQLXMLBulkLoad4Class' cannot be embedded. Use the applicable interface instead.    C:\Users\coopere.COOPERE-PC\documents\visual studio 2010\Projects\Aztech - Bulk Load\Aztech - Bulk Load\Program.cs  15  35  Aztech - Bulk Load</p>
  </blockquote>
  
  <p>Error 7:</p>
  
  <blockquote>
    <p>Interop type 'SQLXMLBULKLOADLib.SQLXMLBulkLoad4Class' cannot be embedded. Use the applicable interface instead.    C:\Users\coopere.COOPERE-PC\documents\visual studio 2010\Projects\Aztech - Bulk Load\Aztech - Bulk Load\Program.cs  15  86  Aztech - Bulk Load</p>
  </blockquote>
  
  <p>Thanks for your help in advance.</p>