>I have several DTS Packages in MS SQL Server that I need to execute.
>
>Here is my plan presently:
>I will have a front end app that the user picks a file to import, that I process in VFP and put the results into SQL Server. I then need to execute the DTS Package which will let SQL Server handle all the heavy duty processing across the multiple tables from my pre-processed file and then when finished, I can simply tell the user it was a success or a failure.
>
>If anyone has any experience or any ideas I would greatly appreciate them.
>
>Thanks in advance !!!
>
>Best Regards,
>Jace Cashion
>Senior Business Analyst/Group Manager
>Micro Strategies, Inc.
>Genesys Technologies

Take a look at MSKB#Q247356 "HOWTO: Execute a SQL Server 7.0 DTS Package from Visual FoxPro"