SQL Server Import and Export Wizard error

• thamilanga

  Ten Centuries

  Points: 1355

  More actions

  March 26, 2012 at 8:58 am

  #253720

  Hi

  I'm using the SQL Server Import&Export tool to update records by deleting the existing table and I'm getting the error below:

  TITLE: SQL Server Import and Export Wizard

  ------------------------------

  Error 0xc002f210: Preparation SQL Task 1: Executing the query "TRUNCATE TABLE [dbo].[Output] " failed with the following error: "Cannot truncate table 'dbo.Output' 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.

  Is there a walkaround this error without dropping the FOREIGN KEY constraint?

  Please assist.

  Thanks

  Thami

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  March 26, 2012 at 9:20 am

  #1464347

  Yes, there is. Use DELETE FROM yourtable.

• thamilanga

  Ten Centuries

  Points: 1355

  More actions

  March 27, 2012 at 12:40 am

  #1464728

  Hi Lynn

  In the import&export wizard I'm selecting the option to "DELETE FROM the existing table" and I get the same error.

  Thanks