Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Data transfer

Author  Topic 

DBA007
Posting Yak Master

145 Posts

Posted - 2010-06-10 : 06:21:04
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.

DBA007
Posting Yak Master

145 Posts

Posted - 2010-06-10 : 07:28:45
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)
Go to Top of Page
   

- Advertisement -