Thank you Sergey,
I have to have all of this functioning by this coming Monday and was a little bit overwhelmed at the direction to take and what was going to work.
You saved me !!!
Thanks again !!!
>>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"