Check out this link, it shows how to execute DTS packages from Visual Basic. You should be able to do the same from VFP through COM:
http://www.sqldts.com/default.aspx?6,104,208,7,1Roman
>Hi all,
>I have created a DTS package to transfer data in Local Packages of SQL Server.
>I wish to call and run it programmatically from my VFP application.
>besides use set time schedule, any other method to call it? such as use EXEC command
>to execute the package name, is it possible?
>thanks for any help.
Roman Rehak, MCSD, MCDBA, MCSA
Competitive Computing
354 Mountain View Drive
Colchester, VT 05446-5824
802-764-1729