The import is done using the import task in SSMS. I've also saved it as a dtsx file.

I can manage to do a straight import from 1 dbs to another dbs without truncating data, but if I try to copy the data to another table in the...

The destination data types are also float. All the longitudes and latitudes are limited to the -80 long and 43 lat range (the table records bus stops for a transit...