>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?
True, you can use Windows Task scheduler. You can also use SQL Server Agent. Windows Task Scheduler is good for (among other things) general executables, whereas Agent is probably a better choice for running SSIS packages and other types of SQL jobs on a schedule. You do have to set up ownership of the agent job and that can mean a few steps, but it gives a bit more control over the package.