I am using DTS to insert about 186,000 records in a fixed length file into a SQL Server 2000 table. The last two columns in the table are latitude and longitude. Currently the datatype in use is float (I also used numeric), but the package fails when trying to insert DBTYPE_STR into DBTYPE_R8. I changed this to varchar and it finishes but instead of lat & long, I get what looks like a date. I know in 2008 I could use a geospatial data type "geography" but I am unfamiliar with using an SSIS package to insert a fixed length file into a geography data type. I would appreciate a little assistance in understanding how to set this up.