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 |
|
jfslater98
Starting Member
7 Posts |
 Posted - 2004-09-08 : 12:25:03
|
| Hello,I am trying to use the MS SQL 2000 DTS wizard to import data from a CSV. It is to append to a table where the ID field value is autogenerated using the Identity property (hope I'm describing this properly). The CSV does not have the identity ID in it, I want to have the DB generate it for me. I get errors saying that it can't insert a Null value, which make sense, but "Enable Identity Insert" is on, so I'm not sure where to go from here. TIA.John |
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2004-09-08 : 12:46:51
|
| Following steps should help1>deselect "Enable Identity Insert" in TRANSFORM tabIn the MAPPING section (also in TRANSFORM),select <IGNORE> for SOURCE for the identity column.------------------------I think, therefore I am |
 |
|
|
jfslater98
Starting Member
7 Posts |
Posted - 2004-09-08 : 13:26:31
|
| never would have thought of that, it worked! Thanks! |
|
|
|
|
|
|
Import with Identity causing problems