[thelist] FTP Scheduler
James Conley
Conleyj at kubota-kma.com
Fri Mar 3 08:15:26 CST 2006
DTS is built into SQL Server starting with version 7.0 IIRC. So you
should have it if you have SQL 2000 or 7.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dtssql/
dts_basic_71v7.asp
DTS can automate [just about] anything in SQL Server. There are DTS
tasks for executing a query/SP, exporting data, importing data, etc.
Combined with the SQL Server Scheduler which can run queries, execute
DOS command-line commands, etc. you should have the tools you need.
james c.
-----Original Message-----
From: thelist-bounces at lists.evolt.org
[mailto:thelist-bounces at lists.evolt.org] On Behalf Of A Maynes
Sent: Friday, March 03, 2006 5:36 AM
To: thelist at lists.evolt.org
Subject: Re: [thelist] FTP Scheduler
Hi thanks do you have a link?
Andrew
-----Original Message-----
From: James Conley [mailto:Conleyj at kubota-kma.com]
Sent: 02 March 2006 20:46
To: thelist at lists.evolt.org
Subject: Re: [thelist] FTP Scheduler
If you are using MS SQL Server then this sure sounds like a job for DTS.
James c
-----Original Message-----
From: thelist-bounces at lists.evolt.org
[mailto:thelist-bounces at lists.evolt.org] On Behalf Of A Maynes
Sent: Thursday, March 02, 2006 4:14 AM
To: thelist at lists.evolt.org
Subject: Re: [thelist] FTP Scheduler
Steven, could yu give any further info on this please? I am
currently looking at running a query on MSSQL saving the file
somewhere locally and then running an upload task (all of this
needs to be automated) so any help/info would be a great help.
Andrew
--
* * Please support the community that supports you. * *
http://evolt.org/help_support_evolt/
For unsubscribe and other options, including the Tip Harvester
and archives of thelist go to: http://lists.evolt.org
Workers of the Web, evolt !
--
* * Please support the community that supports you. * *
http://evolt.org/help_support_evolt/
For unsubscribe and other options, including the Tip Harvester
and archives of thelist go to: http://lists.evolt.org
Workers of the Web, evolt !
More information about the thelist
mailing list