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 |
|
agoodman
Starting Member
3 Posts |
 Posted - 2002-04-24 : 18:00:02
|
| Hello,Read and searched and still need help.New to MS SQL Server, on V7. Actually I run Filemaker Pro with 150 users so bear with me!I have a table which has a identity column incrementing by 1. I have a comma separated file which has all the other columns but this identity column. I do this DTS import (delete rows first), map the columns appropriately and ignore the identity column, and choose insert identity seed (I believe I have tried almost every checkbox combo too). The import fails saying that the identity column is null.I just want this column to kick over when bringing in the data, but I can't get it to. I have to make another CSV with numbers in the identity column for it to work.Hate extra steps, not being able to check the right box and not being able to use my own primary key!Help is greatly appreciated.Adam |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2002-04-25 : 03:16:39
|
| Adam, There's an option on the Advanced tab on the Data Transformation Properties screen called 'Enable identity insert'. If this is checked, DTS will expect you to specify a value for the identity column. If it doesn't get one, the error you mentioned will appear. Uncheck this option and give it another try. You'll also need to check in the Transformations that the identity column isn't being populated with anything from your source file.Give this a shot, and good luck.Tim |
 |
|
|
agoodman
Starting Member
3 Posts |
Posted - 2002-04-29 : 17:56:11
|
| I just tried it again with the enable identity insert unchecked. Nothing is being mapped to it in the transformations. Same situation as before (sigh).Any other ideas? Seems like this should be working.Adam |
|
|
|
agoodman
Starting Member
3 Posts |
Posted - 2002-04-29 : 18:04:16
|
Not to mention that I can bring in a text file with values for the identity, with or without the "enable identity insert" checked and it works.quote:
I just tried it again with the enable identity insert unchecked. Nothing is being mapped to it in the transformations. Same situation as before (sigh).Any other ideas? Seems like this should be working.Adam
|
|
|
|
|
|
|
DTS Import and Identity