Windows Service Control

[John Wildes]

Hello

I have a Windows Forms application that I would like to convert into a
Windows Service. The application queries an SQL server for a particular
set of and then exports it to a network location as a Tab Delimited Text
File. I am going to add some functionality that will also upload this
file to an internal FTP site. This needs to happen on a schedule every
other wednesday. I would also like to keep an interface for this
Windows Service so that I could stop and start the service, change the
schedule, and other options, as well as run an off cycle file creation.
How would I do this? Is it possible to create a windows forms
application that can control a Windows Service? I am very new to
programming so if this question sounds confusing please email me or
reply to the newsgroup with your questions.

Thanks for the help
r/
john wildes

 

[Chris]

Why not use a sql dts package?

 

[Chris]

Let me expand on that.
use a dts package to run 1 time a week and have the dts package fire off a
..exe file that does parces your file..
You already have the over head of sql.. Why not use it.

 

[John Wildes]

I was thinking about that, can SQL DTS export results as a TAB Delimited
file ? How about processing the upload to an FTP server? Or would I
write a .NET app handles the last two parts and call that app from the
DTS package?

john