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 |
|
sqllearner
Aged Yak Warrior
639 Posts |
 Posted - 2004-06-28 : 18:35:30
|
| This is pretty straight forward.Iam pumping data from an excel sheet and the destination table in the sql server has an incremental primary key so its not allowing me to do the data pumping..This happens quite often..what should I do |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-06-28 : 18:46:46
|
| In the transformation, just don't have it put data into that column. Or you could create a staging table that doesn't have the identity column. Pump the data into it, then move the data from it to your table using INSERT INTO with a column list that excludes the identity column.Tara |
 |
|
|
sqllearner
Aged Yak Warrior
639 Posts |
Posted - 2004-06-28 : 19:45:50
|
| I tried and the error I was getting was :The number of failing rows exceeds the maximum specified.Insert error,column 1 ("Tracking_id",DBTYPE_18),status 10 :Integrity violation;attempt to insert null data or data which violates constraints.unspecified error |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-06-28 : 19:48:36
|
| You'll need to use the staging table then or turn the identity option often.Tara |
|
|
|
|
|
|
Data pumping poblem