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 |
|
lhoodwinkle
Starting Member
2 Posts |
 Posted - 2005-12-06 : 19:31:11
|
| I have a large number of Access tables that I need to periodically bring to SQL using the DTS Wizard in SQL 2000 (via Ent. Man). I am only interested in bring over the data from the MS Access tables as I had a separate script (application drive) that would create the SQL tables.The problem is this: with SQL 2000 when bringing over the tables, the check box for 'Enable Identity Insert' for each of the tables was checked, this worked fine.With SQL 2005, this checkbox is not checked hence, I have to click 'edit' for each of the table data being brought over and check the 'Enable Identity Insert' box manualy.My question is whether there is a way to have SQL 2005 have this 'Enable Identity Insert Box' checked by default as it did with SQL 2000.Thank you,John |
|
|
Elena
Starting Member
1 Post |
Posted - 2006-01-03 : 11:29:42
|
| It seems there is no way at the moment to do so but this will be fixed with SP1 for sql2005 |
 |
|
|
|
|
|
DTS Wizard SQL 2005 - Enable Identity Insert