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.
| Author |
Topic |
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
 Posted - 2008-01-22 : 12:22:41
|
| Hi i've an identity column where i have it as a seed of 1. I want to move data from a table to my new table with the identity column but am getting an error on this when i run the DTS package. i;ve set the enable identity insert on the option tab in the DTS but that still makes not differences. any help would be great |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-01-22 : 12:48:04
|
| What is the error you are getting? WHat values are you trying to export to column? |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-22 : 23:03:39
|
| You may need to do that with 'insert ... select ... from ...'. |
|
|
|
|
|
|
identity column issues when inserting with DTS