I asked a similar question a while ago. Thanks to John Koziol I was directed to http://support.microsoft.com/support/kb/articles/Q247/3/56.ASP.

HTH

>Hello Group,
>
>I created two dts packages with the DTS wizard that drop a table in my Visual FoxPro 6.0 database and create a new table with the same name and fresh data from SQL Server 7.0.
>
>Every thing is hunky dory while FoxPro is closed but it will not create a table in Visual Foxpro while Foxpro is running. Even if I close the database while foxpro is running it causes an error.
>
>How do I run a dts package in SQL Server from code in FoxPro and have it run correctly?
>
>Thanks
>Jim