Hello Peter,
Thanks to you and John Koziol. That is excellent information.
Thanks Again
Jim
>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