SSIS Validation Error

• EMtwo

  Hall of Fame

  Points: 3498

  More actions

  June 9, 2009 at 4:03 pm

  #134858

  I am trying to save an SSIS Package to execute for a later time. When I select the option to save the package I get the following error:

  Validating (Error)

  Messages

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

  (SQL Server Import and Export Wizard)

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

  (SQL Server Import and Export Wizard)

  Error 0xc004706b: Data Flow Task: "component "Destination 7 - Batches" (497)" failed validation and returned validation status "VS_ISBROKEN".

  (SQL Server Import and Export Wizard)

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

  (SQL Server Import and Export Wizard)

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

  (SQL Server Import and Export Wizard)

  Any ideas?

• aaa121

  SSCertifiable

  Points: 5902

  More actions

  June 10, 2009 at 2:49 pm

  #1007675

  Looks like you're trying to insert a record into a field called "ID" which is an identity field. You either don't want to import a record into that field or use the T-SQL identity_insert off command to override this behaviour

• P Jones

  SSChampion

  Points: 12369

  More actions

  June 11, 2009 at 1:14 am

  #1007810

  Check the component's properties and the "delay validation" option. Setting to true prevents validation before run time.

• EMtwo

  Hall of Fame

  Points: 3498

  More actions

  June 11, 2009 at 7:19 am

  #1007982

  Thanks.