Error import

[richardg]

I am trying to import data from one SQL (MS SQL 2005) table to another. They are supposedly identical in structure. They both have a Primary Key and they both have data. The "destinatio n" table has 4000 records and I want to add the 10,000 records from the other (identical) table.

I am using the SQL Import wizard, and here is the error message:
"Messages Error 0xc0202049:
Data Flow Task:
Failure inserting into the read-only column "ts".
(SQL Server Import and Export Wizard)"

What am I doing wrong?

[MaryN]

I am trying to import data from one SQL (MS SQL 2005) table to another. They are supposedly identical in structure. They both have a Primary Key and they both have data. The "destinatio n" table has 4000 records and I want to add the 10,000 records from the other (identical) table.

I am using the SQL Import wizard, and here is the error message:
"Messages Error 0xc0202049:
Data Flow Task:
Failure inserting into the read-only column "ts".
(SQL Server Import and Export Wizard)"

What am I doing wrong?

richardg, did anyone ever reply to you? help me out please

[grasshopper2]

richardg, did anyone ever reply to you? help me out please

It sounds like ts (a column is set to read only so it won't allow the import, you could try deleting the data (the 4000 records and re-importing over the top it shouldn't take long, and if its a test server (sort of like my setup..then it shouldn't be a problem after you re-import) let me know if it works out. I am really new to this myself, so your mileage may vary but it worked for me I had a similiar error.
Brgds
grashopper2

[MaryN]

It sounds like ts (a column is set to read only so it won't allow the import, you could try deleting the data (the 4000 records and re-importing over the top it shouldn't take long, and if its a test server (sort of like my setup..then it shouldn't be a problem after you re-import) let me know if it works out. I am really new to this myself, so your mileage may vary but it worked for me I had a similiar error.
Brgds
grashopper2

Thanks for the reply, unfortunately cannot delete data, am using a live database and the table has been modified. Am new to this as well, maybe i need to speak to an SQL guru. Thanks all the same.

[flstingray]

To Insert the record you need to change one setting in the SQL Import Export Wizard. Select the Edit... button next to the table destination then check the box for Enable Indentity Insert. This should allow the records to be moved to the new table.

[ck9663]

check the structure of your table. that could be a COMPUTED column or an IDENTITY column.

try uploading your data using the same technique into a new table...then analyze the source and target table...then just do an INSERT INTO...

-- ck