>Thanks for the reponse Kevin, I forgot to mention this will not be an in-house app, this will be an app for salesmen on the road on a laptop, so basically the application will have a button to export the sales and this export will grab the SQL server data and put it into foxpro tables to be sent to the main office. I don't know to much about SSIS but will c# be able to do this automatically using SSIS?
>
>Thanks again.
>
>
You can use C# code to invoke SSIS packages , where the package is deployed on the server.
Probably the biggest potential complication is having the right version of the DTS Runtime namespace (which is used to invoke the SSIS object model). It's changed a bit over the years. Here's a site that covers the basics.
http://www.codeproject.com/Tips/658959/Execute-SSIS-Packge-by-using-Csharp-and-SQL-ServerBottom line, any time I need to get data from one format to another, I usually use SSIS.