June 9, 2009 at 4:03 pm
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?
June 10, 2009 at 2:49 pm
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
June 11, 2009 at 1:14 am
Check the component's properties and the "delay validation" option. Setting to true prevents validation before run time.
June 11, 2009 at 7:19 am
Thanks.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply