question

Bugmesh avatar image
Bugmesh asked

Latitude and Longitude in SQL Server 2000

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.
sql-server-2000sql server 2008geography
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

KenJ avatar image KenJ commented ·
It looks like it's a metadata problem. If I recall correctly, there is be a place in the DTS designer where you get to select the columns within the fixed length file and specify their data types.
0 Likes 0 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.