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 |
|
pafriedl
Starting Member
3 Posts |
 Posted - 2008-06-12 : 11:31:07
|
| I've got a package that has to copy tables from a remote server (sql server 2000 to '05), do a lot of work, then reload those tables to the remote server.The tables on the remote server originally had a column that was type int, no nulls, identity=yes, identity increment=1, and identity seed=1.when I transfer the tables from the remote server, the table, schema, and data come down without a hitch.HOWEVER, when I reload those tables to the remote server, the column in that table loses it's identity properties! This wasn't a problem the first time the package executed because the table came down with identity. But the second time I was unable to execute inserts because I had "incorrect number of values" being passed due to the modified column.Has anyone experienced this problem, and how do you work around or fix it? |
|
|
|
|
|
Identity seeds lost transferring '05 tables to 2k