May 21, 2009 at 1:09 pm
I am trying to move the data from one table to a new table in a new database. However, the primary key is an identity column. I get an error using the DTS package saying cannot insert due to read only field, which is my identity column. How do I resolve this? Any help will be greatly appreciated.
May 21, 2009 at 1:16 pm
First, post in the DTS forum (I'll move this).
Second, you need to pick the columns to move in transfer data task. Leave the identity column out if you don't care about the values moving as the same ones.
If you do, on the options tab of the transfer data task, there is an "enable identity insert" checkbox that you need to check.
May 21, 2009 at 1:18 pm
I did not know there was a DTS forum. Thanks. I am learning as I go. I appreciate it greatly.
May 21, 2009 at 2:11 pm
Worked like a charm. Thanks.
May 21, 2009 at 2:19 pm
You are welcome.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply