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