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 |
|
kshinningstr
Starting Member
24 Posts |
 Posted - 2005-07-08 : 08:57:08
|
| I am importing a text file to SQL Server using DTS Wizard. I have a column, price, with data field float. I am getting an error at loading for rows that have NULL value for price. I have defined in table design to allow price to have NULL values. "Conversion invalid for datatypes on column pair 13 (source column 'col13'(DBTYPE_STR), destination column 'price' (DBTYPE_R8)"How can I handle this problem? |
|
|
Thrasymachus
Constraint Violating Yak Guru
483 Posts |
Posted - 2005-07-08 : 09:09:23
|
| add a transformation thatreplaces nulls with 0.00? Or do that to the file before hand? Import everything into a staging table where everything is nvarchar, scrub the data with queries and then move it into the destination table with SELECT INTO's?Sean RoussyPlease backup all of your databases including master, msdb and model on a regular basis. I am tired of telling people they are screwed. The job you save may be your own.I am available for consulting work. Just email me through the forum. |
 |
|
|
|
|
|
Please Help! Data type error when importing