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 |
|
justkatie83
Starting Member
1 Post |
 Posted - 2005-11-22 : 11:54:52
|
| I am having a hard time importing a CSV file into a table with an Identity column. When I run the Import Wizard, I select the CSV file, the table I want to import into and then I select Transform so I can map the fields. Under Column Mappings, I select Append Rows and then I uncheck Enable identity insert (because I don't want any data imported into the Identity column, I want it to increment on its own). Under the transformation tab, I select tranform information as it is copied to the destinatation and I map all the columns to their corresponding columns. Nothing is mapped to the Identity field. When I run the import, it fails and it tells me that it cannot insert a Null value into the Identity column. I'm not trying to insert a Null value, I want it to auto-populate. What am I doing wrong? |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2005-11-22 : 13:26:01
|
| Try it using bulk insert - a lot simpler.Easiest yp import into a view which excludes the identity - that would probably work with dts too.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Importing data using Identity in Import Wizard