473,395 Members | 1,581 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,395 software developers and data experts.

Windows Service Control

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
3 1407
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
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
by: Will | last post by:
I'm working on a C# Windows Service that needs to monitor serial port communication. Because the .Net framework does not include support for serial communications, I've decided to use the...
5
by: Dhilip Kumar | last post by:
Hi all, I have developed a windows service using the windows service project template in VS.NET. I have used three controls in the service, a timer, performance counter and a message queue...
5
by: andy.g.ward | last post by:
I keep getting this when trying to create an MFC activex control in a c# windows service - anyone got any ideas what the missing module could be??? Exception thrown :...
5
by: pberna | last post by:
Dear all, I built a Web Form application to start and stop a Windows Service remotely. I successful tested the application on Windows 2000 server + IIS. I must include the ASPNET user to the...
1
by: Scott Davies | last post by:
Hi, I'm looking for some help on a small program that I'm trying to develop in VB.NET. I'm having trouble getting the code that I've written to work, can anyone shed some light as to where I'm...
0
by: Scott Davies | last post by:
Hi, I'm looking for some help on a small program that I'm trying to develop in VB.NET. The program I'm trying to develop needs to be able to do the following: - Select remote server -...
3
by: Amjad | last post by:
Hi, I just wrote a test Windows Service that creates a text file on startup (please see my code below). The file is never created. Protected Overrides Sub OnStart(ByVal args() As String) Dim...
2
by: letibal | last post by:
Hello, I have written a windows service and created an installer for it. The service runs under the system accounts. When started, it launches a GUI. By default, the InteractiveProcess property...
2
by: =?Utf-8?B?Sm9obiBG?= | last post by:
Hello All, I have a question about using an ActiveX control with a Windows Servce in C#. I believe it is not possible to properly setup an ActiveX control in a windows service as the particular...
28
by: | last post by:
I have a multi threaded windows form application that runs great after calling Application.Run(). Application.Run is required for a COM component I a using in the app (required for message loop). ...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.