SQL Server Performance

Need help with these error code

Discussion in 'SQL Server 2005 General Developer Questions' started by Groovemaker, May 16, 2011.

  1. Groovemaker New Member

    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
    Warning 0x802092a7: Data Flow Task 1: Truncation may occur due to inserting data from data flow column "SEName" with a length of 255 to database column "SEName" with a length of 100.
    (SQL Server Import and Export Wizard)

    Error 0xc0202049: Data Flow Task 1: Failure inserting into the read-only column "ProductId".
    (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 - Nop_Product" (76)" 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].[Nop_Product] (Stopped)
    - Post-execute (Stopped)
  2. FrankKalis Moderator

    Welcome to the forum!
    SEName in the data flow is defined with a length of 255 while the actual table column only allows 100. This may result in truncation. You should check the column properties in the task.
    Also, looking at the name ProductID I am guessing that you are trying to insert into an identity column. If this is correct, you might either want to remove that column mapping and let SQL Server work out the values for that column, or, if you need to preserve the values, you need to tick the "Enable identity insert" option in the wizard.
  3. Jahanzaib Member

    increase the column length

Share This Page