title: Import one csv file with data for multiple tables in MS SQL server
body: <p>I have the following tables (simplified for question):</p>
  
  <p>Data:</p>
  
  <pre><code>Id
  Serialnumber
  Value
  AddressId (ForeignKey)
  </code></pre>
  
  <p>Addresses:</p>
  
  <pre><code>Id
  Street
  ZipCode
  City
  ...
  </code></pre>
  
  <p>Now I have a csv file which contains data, unfortunately for both tables:</p>
  
  <pre><code>Serialnumber,Value,Street,ZipCode,City, ...
  12345,1140,Fakestreet 3,12345,New York
  5678,830,Fakestreet 87,12345,New York
  </code></pre>
  
  <p>Is there any way to import csv files like that to Microsoft SQL server (2008)? The server itself has to insert the address first, then use the primary key of the Addresses table as foreign key in the Data table.</p>