Hi Brock,

Below things i am doing;

1. Created a console application which would be scheduled to run.

2. This console application would copy files if any from the mapped drive using username and password to the local drive.

3. The local files are processed and the data is added to the MS SQL server database tables.

4. These tables data are then used by some other process to generate reports - THIS POINT IS NOT IN SCOPE OF CONSOLE APPLICATION.

Its only until point 3 that the console application needs to implement.