title: Error 0xc002f210
body: <p>I have just started learning SQL Server, I am trying to use Import Export wizard to import data from excel file to one of the table in the database. But I am getting an error <code>0xc002f210</code>.</p>
  
  <p>I understood only that it is taking length of excel file cell as 255 but the SQL Server table length is different. I am unable to understand why it is happening.</p>
  
  <p><strong>Validating (Error)</strong></p>
  
  <blockquote>
    <p>Warning 0x802092a7: Data Flow Task 1: Truncation may occur due to inserting data from data flow column "Name" with a length of 255 to database column "Name" with a length of 50.<br>
    (SQL Server Import and Export Wizard)</p>
    
    <p>Warning 0x802092a7: Data Flow Task 1: Truncation may occur due to inserting data from data flow column "GroupName" with a length of 255 to database column "GroupName" with a length of 50.<br>
    (SQL Server Import and Export Wizard)</p>
    
    <p>Error 0xc002f210: Preparation SQL Task 1: Executing the query "TRUNCATE TABLE [HumanResources].[Department]<br>
    " failed with the following error: "Cannot truncate table 'HumanResources.Department' because it is being referenced by a FOREIGN KEY constraint.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.<br>
    (SQL Server Import and Export Wizard)</p>
  </blockquote>