MS SQL Server 2000
I have a tab-delimited text file with a header row, the last 3 columns of which are of the data type "real". The last column needs to be imported as null. I am trying to import this file through DTS.
A row in the tab-delimited text file looks like this:
info <tab> info <tab> 0 <tab> 0 <tab> null
I am getting an error during the DTS process:
"Conversion invalid for datatypes on column pair 5 (source column 'nDistance' (DBTYPE_STR),destination column 'nDistance' (DBTYPE_R4)).
I don't understand why it's seeing the last column as a string.
How can I solve this?