I am getting the following error when I am trying to copy a text file to an
exsisting sql server 2000 table.

"Error during transformation 'directCopyxform' for row number 1234. Errors
encountered so far in this task: 1.
transformationcopy 'Direct Copyxform' conversion error: conversion invalid
for datatypes on column pair 14 9source column 'col014' (dbtype_str),
destination column 'lat' (dbtype_r8)).
When using the dts wizard and clicking on transformations, and clicking on
another tab called 'transformations'. After this, I click the option called
'transform information as it is copied to the destination, the is vbscript
code that looks like:
Can you tell me how to convert a string type to a real float number here
or somewhere else in the dts package?
function main()
dtsdestionation("lat")=dtssource("col014)
end function

Thanks!