I have a table that contains IP adresses from visitors to my website. I would like to create a new table that includes both the IP address and the Reverse lookup name. I'm running 2000 Advanced Server and SQL 2000.

I'm thinking that I run a DTS package that uses some kind of Dns.GetHostByAddress method as it populates the new table. This is not my normal job, so I am really very much a newbie in the field.

I also thought about somehow using NSLookup to pass the name value, but I'm really not sure how that would work.

If anyone has any suggestions, I would really appreciate it.