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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-09-11 : 14:08:30
|
| Adam writes "I have a DTS package that imports a comma delimited text file into a SQL 2000 table. The field is a "float" and the value in the corresponding field in the text file is zero. I am getting the following error when trying to run the DTS package:"The number of failing rows exceeds the maximum specified. TransformCopy 'DTSTransformation_83' conversion error: Conversion invalid for datatypes on column pair 1(source column('ColName'(DBTYPE_STR), destination column 'ColName'(DBTYPE_R8))."I have no idea whta the heck DBTYPE_R8 is!?!thanks,a." |
|
|
ksw
Starting Member
24 Posts |
Posted - 2002-09-13 : 12:39:53
|
quote:
I have no idea whta the heck DBTYPE_R8 is!?!
DBTYPE_R8 means a REAL SQL Server data type & DBTYPE_STR means CHAR or TEXT. Since I think your error message is saying that it can't put your source char data into your destination real (float) field, I would check to make sure that in the text file properties of your source file, that the check box "First Row Has Column Names" is set correctly. If you have column names in your file, you have to check this box. The only other thing I could suggest would be to make sure that the other settings in that properties box are correct and that the 0 in your file isn't being considered text, ie. does it have quotes around it.Hope this helps,--KSW |
 |
|
|
ksw
Starting Member
24 Posts |
Posted - 2002-09-13 : 12:46:32
|
| Leave it to BOL to be inconsistent. I found another help topic that said that DBTYPE_R8 is for the SQL Server FLOAT data type, not REAL like the first topic I read. Anyway, the rest of what I said is right.--KSW |
|
|
|
|
|
|
Transform Data Task Conversion Invalid Error