Import Export Wizard Error

• tripri

  SSCommitted

  Points: 1584

  More actions

  August 4, 2010 at 11:26 am

  #238446

  Hi,

  I'm just importing some tables from one server to another server.

  But now i'm getting this error. Can you please help me out with this...

  I'm using SQL SERVER 2008 databases...

  Operation stopped...

  - Initializing Data Flow Task (Success)

  - Initializing Connections (Success)

  - Setting SQL Command (Success)

  - Setting Source Connection (Success)

  - Setting Destination Connection (Success)

  - Validating (Error)

  Messages

  Error 0xc0202049: Data Flow Task 1: Failure inserting into the read-only column "rowversion".

  (SQL Server Import and Export Wizard)

  Error 0xc0202045: Data Flow Task 1: Column metadata validation failed.

  (SQL Server Import and Export Wizard)

  Error 0xc004706b: Data Flow Task 1: "component "Destination - GroupMap" (40)" failed validation and returned validation status "VS_ISBROKEN".

  (SQL Server Import and Export Wizard)

  Error 0xc004700c: Data Flow Task 1: One or more component failed validation.

  (SQL Server Import and Export Wizard)

  Error 0xc0024107: Data Flow Task 1: There were errors during task validation.

  (SQL Server Import and Export Wizard)

  - Prepare for Execute (Stopped)

  - Pre-execute (Stopped)

  - Executing (Success)

  - Copying to [dbo].[GroupMap] (Stopped)

  - Post-execute (Stopped)

• Adiga

  One Orange Chip

  Points: 27284

  More actions

  August 4, 2010 at 1:27 pm

  #1202345

  You may want to cross check the column mappings. Please refer this article

  Pradeep Adiga
  Blog: sqldbadiaries.com
  Twitter: @pradeepadiga