title: Error 0xc0202049: Data Flow Task 1: Failure inserting into the read-only column
body: <p>I am using SQL Server 2008 import and export wizard. I need to import a database. I opened the SQL server import/export wizard and I went through the following actions:-</p>
  
  <ol>
  <li><p>for the destination I chose "SQL server native client 10".</p></li>
  <li><p>then I selected copy data from one or more tables or view.</p></li>
  <li><p>SSIS run immediately</p></li>
  </ol>
  
  <p>but i got the following errors, </p>
  
  <blockquote>
    <p>Operation stopped...</p>
    
    <ul>
    <li><p>Initializing Data Flow Task (Success)</p></li>
    <li><p>Initializing Connections (Success)</p></li>
    <li><p>Setting SQL Command (Success)</p></li>
    <li><p>Setting Source Connection (Success)</p></li>
    <li><p>Setting Destination Connection (Success)</p></li>
    <li><p>Validating (Error)</p></li>
    </ul>
    
    <p>Messages Error 0xc0202049: Data Flow Task 1: Failure inserting into
    the read-only column "ActionID".  (SQL Server Import and Export
    Wizard)  </p>
    
    <p>Error 0xc0202045: Data Flow Task 1: Column metadata validation failed.
    (SQL Server Import and Export Wizard)  </p>
    
    <p>Error 0xc004706b: Data Flow Task 1: "component "Destination -
    AuditActions" (22)" failed validation and returned validation status
    "VS_ISBROKEN".  (SQL Server Import and Export Wizard)</p>
  </blockquote>
  
  <p>It seems that I can not import identity columns and timestamps columns, so how I can force these values to be imported?</p>