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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-01-28 : 08:26:34
|
| Jalise writes "Is there a way for the server(I'm on SQL 2000) to automatically generate a unique ID when the data is imported using DTS? I created a new table with a TESTID column's properties set to IDENTITY Yes, IDENTITY Seed = 1, IDENTITY Increment =1. I was trying to import (using DTS) 50 records as a test and the server rejected the import because TESTID can not accept NULL. Well, I know that because I wanted this column to automatically generate a unqiue ID for me. Am I doing this incorrectly? HELP" |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2005-01-28 : 11:14:34
|
| You need to modify your data pump task (or bulk insert task ... whatever the case may be) such that it doesn't try to insert into your TestID column. For a DPT, remove the transformation. For a BIT modify your format file.Jay White |
 |
|
|
|
|
|
IDENTITY