Geocoding in SQL Server 2000 DTS Package

Anyone have any examples or information on how to best accomplish
geocoding in a SQL Server 2000 DTS package?
Spencer"stabbert" <spencer@.tabbert.net> wrote in message
news:1152191801.603777.125550@.j8g2000cwa.googlegroups.com...
> Anyone have any examples or information on how to best accomplish
> geocoding in a SQL Server 2000 DTS package?
> Spencer
>
How are you doing your geocoding? Are you trying to store lats and longs?
A key that maps to lats and longs? Are you using a zipcode, or county, or
state value to determine your geocoding?
Rick Sawtell
MCT, MCSD, MCDBA|||We are attempting to store lattitude and longitude based upon full US
addresses. We need the lattitude and longitude as the input will be
the address.
Spencer
Rick Sawtell wrote:
> "stabbert" <spencer@.tabbert.net> wrote in message
> news:1152191801.603777.125550@.j8g2000cwa.googlegroups.com...
> How are you doing your geocoding? Are you trying to store lats and longs?
> A key that maps to lats and longs? Are you using a zipcode, or county, or
> state value to determine your geocoding?
>
>
> Rick Sawtell
> MCT, MCSD, MCDBA|||Here's as start, but you need SQL Server 2005.
http://msdn.microsoft.com/library/d...
alFuncSQL.asp
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"stabbert" <spencer@.tabbert.net> wrote in message
news:1152231254.150274.286890@.s13g2000cwa.googlegroups.com...
We are attempting to store lattitude and longitude based upon full US
addresses. We need the lattitude and longitude as the input will be
the address.
Spencer
Rick Sawtell wrote:
> "stabbert" <spencer@.tabbert.net> wrote in message
> news:1152191801.603777.125550@.j8g2000cwa.googlegroups.com...
> How are you doing your geocoding? Are you trying to store lats and longs?
> A key that maps to lats and longs? Are you using a zipcode, or county, or
> state value to determine your geocoding?
>
>
> Rick Sawtell
> MCT, MCSD, MCDBA|||I have written a VBscript that will be embeded in a DTS package that
will use the MSXML2.ServerXMLHTTP.3.0 object to make calls to the
Google and Yahoo API used for geocoding. The simple HTTP calls are all
that I need and are simple. I can then get the elements I need out of
the XML returned. I plan to expand this eventually ontok.com and
geocoder.us for commercial type applications and they offer the same
simple HTTP REST interface.
Spence

Geocoding in SQL Server 2000 DTS Package

Anyone have any examples or information on how to best accomplish
geocoding in a SQL Server 2000 DTS package?
Spencer"stabbert" <spencer@.tabbert.net> wrote in message
news:1152191801.603777.125550@.j8g2000cwa.googlegroups.com...
> Anyone have any examples or information on how to best accomplish
> geocoding in a SQL Server 2000 DTS package?
> Spencer
>
How are you doing your geocoding? Are you trying to store lats and longs?
A key that maps to lats and longs? Are you using a zipcode, or county, or
state value to determine your geocoding?
Rick Sawtell
MCT, MCSD, MCDBA|||We are attempting to store lattitude and longitude based upon full US
addresses. We need the lattitude and longitude as the input will be
the address.
Spencer
Rick Sawtell wrote:
> "stabbert" <spencer@.tabbert.net> wrote in message
> news:1152191801.603777.125550@.j8g2000cwa.googlegroups.com...
> > Anyone have any examples or information on how to best accomplish
> > geocoding in a SQL Server 2000 DTS package?
> > Spencer
> >
> How are you doing your geocoding? Are you trying to store lats and longs?
> A key that maps to lats and longs? Are you using a zipcode, or county, or
> state value to determine your geocoding?
>
>
> Rick Sawtell
> MCT, MCSD, MCDBA|||Here's as start, but you need SQL Server 2005.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/TblValFuncSQL.asp
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"stabbert" <spencer@.tabbert.net> wrote in message
news:1152231254.150274.286890@.s13g2000cwa.googlegroups.com...
We are attempting to store lattitude and longitude based upon full US
addresses. We need the lattitude and longitude as the input will be
the address.
Spencer
Rick Sawtell wrote:
> "stabbert" <spencer@.tabbert.net> wrote in message
> news:1152191801.603777.125550@.j8g2000cwa.googlegroups.com...
> > Anyone have any examples or information on how to best accomplish
> > geocoding in a SQL Server 2000 DTS package?
> > Spencer
> >
> How are you doing your geocoding? Are you trying to store lats and longs?
> A key that maps to lats and longs? Are you using a zipcode, or county, or
> state value to determine your geocoding?
>
>
> Rick Sawtell
> MCT, MCSD, MCDBA|||I have written a VBscript that will be embeded in a DTS package that
will use the MSXML2.ServerXMLHTTP.3.0 object to make calls to the
Google and Yahoo API used for geocoding. The simple HTTP calls are all
that I need and are simple. I can then get the elements I need out of
the XML returned. I plan to expand this eventually ontok.com and
geocoder.us for commercial type applications and they offer the same
simple HTTP REST interface.
Spence

Generating DTS flat file connection

I'm trying to generate a DTS Package with VB.Net using the Microsoft DTSPackage Object Library and
and the Microsoft DTSDataPump Scripting Object Library
I have to load csv files into SQL tables.
I could generate both a SQL connection and a FlatFile connection and the transformationtask.

When I look at the transformationtask and click on the transformation tab I get this error

"Incomple file format information"

The problem is I don't find where I could set the FlatFile connection properties like "Text Qualifier" and
"row delimiter"

I tried this but it still shows CRLF as row delimiter when I look at the generated DTS Package

Dim oConnection As DTS.Connection2
Dim package As DTS.Package2
Dim filename As String
filename = "myfilename.csv"

oConnection = package.Connections.New("DTSFlatFile")
oConnection.Name = filename
oConnection.ConnectionProperties.Item("Row Delimiter").Value = vbTabWhy not just bcp the file out using a stored porcedure?

Generating an SQL script for a DTS Package

Can an SQL script be generated for a DTS package? I need to be able to
create script to recreate every object that relates to the normal
functioning of the database. Most other objects are easy to get an
executable script to recreate. I can't seem to figure this one out.
Thank you,
JulianDTS packages can include non-SQL structures like VBscripts etc. So the only
ways, you can save them as structured storage file, VB file, Metadata
Service or as binary data in MSDB database. Each of the options can be found
in SQL Server Books Online under the topic "saving DTS packages"
Anith

Generate SQL Script using a DTS

Hi
Each month I back up the structure of our databases by right-clicking
on each database and select Generate SQL Script...

>From the General tab I select script all objects and from the Options
tab I select script database, along with script indexes and script
primary keys.
As we have several databases this can take some time. Is there away to
automate this using a DTS?
Thanks
MattI don't know if DTS is the way to go but you can certainly use DMO to do
this. In fact, the sample code is included with SQL. All you need to do is
modify it to run automatically and then invoke from s DTS package.
Alternatively, you could use the SP_OA family of procedures to do it. At my
last job, we scripted out some objects just this way.
"matt.cottam@.googlemail.com" wrote:

> Hi
> Each month I back up the structure of our databases by right-clicking
> on each database and select Generate SQL Script...
>
> tab I select script database, along with script indexes and script
> primary keys.
> As we have several databases this can take some time. Is there away to
> automate this using a DTS?
>
> Thanks
> Matt
>|||Yes, have a look at SQL DMO library, you could use it within an ActiveX
script in DTS.
"matt.cottam@.googlemail.com" wrote:

> Hi
> Each month I back up the structure of our databases by right-clicking
> on each database and select Generate SQL Script...
>
> tab I select script database, along with script indexes and script
> primary keys.
> As we have several databases this can take some time. Is there away to
> automate this using a DTS?
>
> Thanks
> Matt
>

generate filename from today

Hi,
I have to create an ascii file which name format is like vyymmdd.txt
What would be the best way to do this?

I have used DTS package to do this but file neme must change every day.
rgds
KariHi Kari
could you specify from where you create the file and what for?|||Hi,
I have a sqlserver table and I would like to generate each day a text file from that.
rgds
Kari|||Is this what you're looking for?!

select 'v' + convert(char(6), getdate(),12)+'.txt'

Regards,
Clifford Dibble