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 |
|
danyeung
Posting Yak Master
102 Posts |
 Posted - 2007-09-05 : 12:27:45
|
| I used Import Data to create a table and import data. The table was created but I got an error during the import "Error at Destination for Row number 14. Error encountered so far in this task: 1. Unspecified error." According to Microsoft link http://support.microsoft.com/kb/q228933/, it was NULL value was moved into a NOT NULL value column. The destination table was created from the source table. The data types are identical. Why the error still occurred?I also highlighted the rows in the source table and pasted them into the destination table. All columns with decimal(38,0) are NULL, but columns with decimal(8,0) are with number or NULL. Any Idea why decimal(38,0) contains NULL only?Thanks,DanYeung |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-09-05 : 12:37:06
|
Conversion error?
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
danyeung
Posting Yak Master
102 Posts |
Posted - 2007-09-05 : 13:12:03
|
| Did you mean converting to different data type? The table was created from the source table. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-05 : 23:16:45
|
| You may need set destination column to accept null value as well. |
|
|
|
|
|
|
Unspecified Error