By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,165 Members | 1,508 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,165 IT Pros & Developers. It's quick & easy.

Windows Service Control

P: n/a
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
Nov 21 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Why not use a sql dts package?
"John Wildes" <jw*****@gmail.com> wrote in message
news:OO**************@tk2msftngp13.phx.gbl...
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

Nov 21 '05 #2

P: n/a
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" <jw*****@gmail.com> wrote in message
news:OO**************@tk2msftngp13.phx.gbl...
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

Nov 21 '05 #3

P: n/a
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
Chris wrote:
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" <jw*****@gmail.com> wrote in message
news:OO**************@tk2msftngp13.phx.gbl...
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


Nov 21 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.