>Since you can move your data upwards and it's your VFP program that knows when there is newly processed information, why don't you hook in a VFP process/routine to send the data to your staging database? What difference does it make if the information was put in there by a stored procedure or by an external application? If there must be a stored procedure in the SQL Server that the third party system calls in order to feed its processes, does it matter if such stored procedure fetches and passes along data that is already in the server?
>
>
>>Hi Community,
>>
>>Does anyone know how to write a SQL Server 2008 stored procedure to retrieve data from FoxPro. I have payroll data in visual FoxPro that a third party vendor needs access. The vendor uses SQL Server. I created a staging database on SQL Server. I need to run a stored procedure in SQL Server to get the data after processing has occurred in my FoxPro payroll program. I know how to send data from FoxPro to SQL, but my scenario I will have to provide a store procedure that has to be initiated from SQL Server to get my dbf data. I was unable to find anything on the internet where someone has attempted to retrieve dbf data from SQL Server. Any help, much appreciated. FoxPro still rules.
>>
>>
>>thanks
>>Nick

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?