Home Forums Article Discussions Article Discussions by Author Discuss content posted by Oscar D Garcia Map IP Address to a Geographical Location RE: Map IP Address to a Geographical Location

  • April 18, 2010 at 10:48 pm

    #1153579

    Lowell (4/16/2010)

    i must have tunnel vision this morning;

    i didn't see any BULK insert scripts for the files; after downloading the csv files, i see they are UNIX style(slash r for the row delimiter, right?), but they are also dbl-quote delimited, so i need a format file.

    did anyone already do this, or do i need to get some coffee and sweat it out?

    I built a quick SSIS 2008 package to do this, it truncs the table and then repopulates it from the files.

    http://downloads.novaconceptsltd.com/SSC/GeoLiteLoad.zip

    Put files in C:\Temp

    Pretty straightforward package..

    CEWII