title: Populating aspnet_Profile table via TSQL
body: <p>I'm trying to bulk load the aspnet members via TSQL from CSV File or Database sources. I'm happy with any other options i.e. net application or ssis packages.</p>
  
  <p>The problem I'm facing is that each members have a their own profile as blow:</p>
  
  <blockquote>
    <ol>
    <li>First Name</li>
    <li>Last Name</li>
    <li>Mobile</li>
    <li>Company Add .... etc.</li>
    </ol>
  </blockquote>
  
  <p>Looks like aspnet profile is stored as </p>
  
  <blockquote>
    <p>PropertyNames and PropertyValues</p>
  </blockquote>
  
  <p>in backend aspnet_profile table.</p>
  
  <p>Could anyone please suggest me how I can load the employee data and their profile on to aspnet membership database?</p>
  
  <p>Thanks.</p>