ComputerNovice
Baseband Member
- Messages
- 22
I need to write a program that will connect to a Microsoft Server 2008 database and write the contents of a table into an Excel file, which will be saved on the directories of multiple workstations. Lastly, this program will clean up the target directory of any files older than 3 days. This program will be kicked off by Control M scheduler.
I am comfortable with C# and SQL. But I'm only familiar with connecting a GUI program to a database and displaying the data to the user, on a Windows form.
Is this still possible with a C# program, such as a console application? Maybe even VB?
Or do I need to do this in another scripting language, such as a T-SQL script? I wasn't sure if T-SQL can even clean up directories of old files.
Any pointing in the right direction would be greatly appreciated!
I am comfortable with C# and SQL. But I'm only familiar with connecting a GUI program to a database and displaying the data to the user, on a Windows form.
Is this still possible with a C# program, such as a console application? Maybe even VB?
Or do I need to do this in another scripting language, such as a T-SQL script? I wasn't sure if T-SQL can even clean up directories of old files.
Any pointing in the right direction would be greatly appreciated!