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 |
|
pelegk2
Aged Yak Warrior
723 Posts |
 Posted - 2007-10-11 : 05:44:50
|
| how can i make bulk upload to a table with identity columnwithought going through a TempTable first.thnaks i nadvancepelegIsrael -the best place to live in aftr heaven 9but no one wan't to go there so fast -:) |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-10-11 : 05:53:14
|
| Do you want SQL Server to assign identity values automatically or do you want to load them from file?Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
pelegk2
Aged Yak Warrior
723 Posts |
Posted - 2007-10-11 : 06:04:53
|
| i want SQL Server to assign identity values automatically .i forgot to mantain that i do this upload using a fromat filethanksPelegIsrael -the best place to live in aftr heaven 9but no one wan't to go there so fast -:) |
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-10-11 : 06:12:21
|
| How you are uploading the data? using BCP or Bulk Insert?Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
pelegk2
Aged Yak Warrior
723 Posts |
Posted - 2007-10-11 : 06:13:24
|
| bcpIsrael -the best place to live in aftr heaven 9but no one wan't to go there so fast -:) |
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-10-11 : 06:29:56
|
| Are you specifying -E option with BCP?Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-11 : 06:58:47
|
| "Are you specifying -E option with BCP?"That's if the IDs are already in the file and you want SET IDENTITY_INSERT ON - isn't it?"i want SQL Server to assign identity values automatically"Surely it will do this anyway - if you don;t provide a value for the ID column?Or I'm being more thick than normal this morning!Kristen |
|
|
|
pelegk2
Aged Yak Warrior
723 Posts |
Posted - 2007-10-11 : 07:08:57
|
| it worsi work with format files so no need to add a column for the identity thanksallpelegIsrael -the best place to live in aftr heaven 9but no one wan't to go there so fast -:) |
|
|
|
|
|
|
bulk upload identity