Using MapPointBatcHGeocode for ESRI's MapIt

Nov 18, 2009 at 8:22 PM

A bit rusty with geocoding, and never was that proficient.  In any event, here's my issues:

1) I can't fill in anything for MapPoint DataSourceName, MapPoint Password, MapPoint UserName, MapPoint UserStaging -- I get a drop down list option, but the drop down list is blank and I can't type anyting in.

2) I see where the output is SqlGeography, I understand that ESRI MapIt is looking for a Geometry data type.

3) Maybe I missed it, but it would be great to get a step-by-step, hello world kind of example.

4) I don't have city names, but I do have zip codes -- good enough to get a Geometry point?

Thanks and appreciate the effort for an SSIS geocoder.

Feb 18, 2011 at 11:31 PM

The DataSourceName, etc. input column properties refer to user variable names. The drop-down lists will be empty if you haven't defined any variables.

There is a notice on the MapPoint Customer Services site that says:

IMPORTANT NOTICE: MapPoint Web Service will be discontinued on November 18, 2011.

It links to http://www.microsoft.com/maps/mappoint.aspx for information about migrating code to use Bing Maps.