Hi All,


I have a 3rd party app that will take a single address and
parse it and starndardize it for me so that I can store
the parts of the address in my table. Table DDL below.

When we insert a row into this table through the app (one
at a time entry/update), it's handled through a dll on the
3rd party.

Now I have a table of address that I have to push through
this app. I can create the ActiveX script to get the data
and loop through them one at a time, but I don't know how
to use this dll that I have.

I have run these through the dll and take the output and
insert into my table.

that make any sense?

When you say it parses the address for you???

Do you mean that you get an address in Comma delimited and it SPLIT() on the
comma or does it do some funky stuff.

Does the dll have an associated object model you could use.?

If it does then you could register the dll and then use CREATEOBJECT() in an
ActiveX task and send the data to it using that.

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know


"Steve" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Thanks for the quick replay Allan.

It will take an address that looks like this:

123 W. Sunshine Ave

and put in in my table as this:
HouseNumber StreetPrfix StreetName StreetSuffix
123 W Sunshine Ave

note this is a simple example. The parser is capable of
doing very complicated address with suite numbers,
apartment number and so on. I have more columns in the
table to handle that.

I have ~6500 address that need to be converted.

I registered the dll on my server.

I don't know if the dll has an associated object model?

Ok

You may be able to mimic what the parser does in VBScript but if you do not
want to reinvent the wheel I woould ask the 3rd party for an API to their
dll and do it that way.


--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know


"Steve" <anonymous (AT) discussions (DOT) microsoft.com> wrote