In the first installment on this topic, I used a commercial text editor, EditPad Pro , to perform the Unicode file conversion and SQL Server BULK INSERT to load the data. In this installment, I'm going to change to workflow a bit to use of Microsoft's...

In his post last year, Integrating Virtual Earth and GeoNames , Johannes described how to load the GeoNames database into SQL Server using the "Import Data" Wizard in SQL Server Management Studio. In his scenario, Johannes did not need to take...