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 |
|
mdhingra01
Posting Yak Master
179 Posts |
 Posted - 2006-01-04 : 11:03:43
|
| I am inserting records from a Foxpro table into a SQL Server table. I recreated the same Table structure for the destination table. I start my insert and it inserts almost 70%, then gives me an Insert Error: COlumn 20 (Estimated, dbtype_numeric) Status 12 : Invalid status for bound data. Unspecified error.Any help would be appreciated in recrifying this problem.Thanks |
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2006-01-04 : 12:50:57
|
| I'm guessing that is a Foxpro error message, because I don't recognize it.Instead of recreating your Foxpro table in SQL Server, try creating a representation of it as a heap (no indexes, no constraints, no foreign keys...). You might also consider making all the destination fields varchar. This should allow you to load just about anything into the table without SQL Server generating any errors, and then you can verify, clean, and transform the data in this staging table as necessary when you load the data into your production table. |
 |
|
|
|
|
|
Insert error