[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