June 10, 2010 at 4:21 am
Friends,
when iam transfering data from one db to another db in two different servers using DTS wizard,the error message DTS throws is destination table contains readonly column and the transfer fails.
June 10, 2010 at 5:29 am
This is the actual error message.
- Validating (Error)
Messages
•Error 0xc0202049: Data Flow Task: Failure inserting into the read-only column "GId".
(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 - psiCurrentPoHeader" (46)" 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)
June 10, 2010 at 5:34 am
dba_neo (6/10/2010)
Friends,when iam transfering data from one db to another db in two different servers using DTS wizard,the error message DTS throws is destination table contains readonly column and the transfer fails.
Check whether you have Identity column.
June 10, 2010 at 6:55 am
Make sure you have similar columns & data type defined in both DBs
----------------------------------------------------------------
**"There is only one difference between dream and aim. Dream requires Soundless sleep to see…Where as Aim Requires Sleepless Efforts to Achieve":-) **
June 10, 2010 at 11:28 am
the tables have identity colums
June 10, 2010 at 11:40 am
I thought there was a checkbox in DTS to handle identity columns, but basically you cannot directly insert into an identity column without marking it as available for insert.
June 10, 2010 at 10:58 pm
dba_neo (6/10/2010)
the tables have identity colums
set identity insert on
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply