You could use Windows Task Scheduler. It can automated to run a program (your uploader, in this case) at a specific time and day of week. Here's a link to the official Microsoft documentation:
http://technet.microsoft.com/en-us/library/cc721871.aspx.
>I'm unsure how to automate the upload process. The scenario is as follows:
>1: Our accounts payable downloads the data from payroll processing center every couple of weeks.
>2: Once this data is downloaded, our accounts payable people need to add additional info into the payroll data that was downloaded
>3: Then I need to create a process to have this data sent to the SQL Server on weekend automatically.
>
>I like the idea of creating FoxPro process to send the data instead of sql server initiating the capture of data (which may not work because of 64 bit issue), but I don't know how to automate this Visual FoxPro data export to SQL Server process. That is why I was going the integration services route. If I create a VFP program to populate sql server table, how do I run this process automatically on every couple of weekends?
----------------------------------
António Tavares Lopes