As I mentioned in earlier posts, I also have a ssis package scheduled to generate the file, then a different windows service with filewatcher which watch the designated folder for the new file created by ssis, when the new file created, this service copies the file to another folder.

I design this test windows service to combine the two, ssis & the service above to one service.

as you suggest, I did have a service working which is the filewatcher above. But the new service does not work.

If you think OnStart is not the place, could you tell where is the right place. I have googled for 3 days now, everybody talk and discuss, but no sample codes available, I would like to see a sample that call a sp successfully, to build my detail based on the sample, just forget the details inside my stored procedure. I need a sample just as a framework to develop my details.

As I mentioned in my original post, I need a sample codes, then I can figure out from there.

Thanks.