Run a view and Export results as a CSV file

I need to automate a process for a client and not sure how I can achieve the
following. any help on this would be appreciated.
1. Run a View for the results set
2. Export this data to a csv file.
3. Run a batch job which FTP's the data to an off site server.
Note I have developed the view for my data and know how to implement the FTP
transfer using a batch file/Command. What I don't know is how to export the
results automatically at the end of the view and executing the batch job.
Regards
Jeff
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.762 / Virus Database: 510 - Release Date: 13/09/2004
One option is to use DTS to do this.
You can use a data pump task to select from the view. Use a
text destination connection for the destination file and set
this to be a csv file. Then use an execute process task to
execute your batch job or you can use it to execute the
command line FTP to send the files to the FTP site.
-Sue
On Wed, 15 Sep 2004 07:30:03 +1000, "Jeff Williams"
<jeff.williams@.hardsoft.com.au> wrote:

>I need to automate a process for a client and not sure how I can achieve the
>following. any help on this would be appreciated.
>1. Run a View for the results set
>2. Export this data to a csv file.
>3. Run a batch job which FTP's the data to an off site server.
>Note I have developed the view for my data and know how to implement the FTP
>transfer using a batch file/Command. What I don't know is how to export the
>results automatically at the end of the view and executing the batch job.
>Regards
>Jeff
>
>--
>Outgoing mail is certified Virus Free.
>Checked by AVG anti-virus system (http://www.grisoft.com).
>Version: 6.0.762 / Virus Database: 510 - Release Date: 13/09/2004
>