Hello,

I have a DTS packet that I use to update a Visual FoxPro table. Since
this table is not a truly visual fox pro table, I am using dBASE IV
connection to update it.

The package drops the table, creates it again and then copies data
from a sql server table to the foxpro(.dbf) table.

The package runs fine from sql server.

When I execute the package from the ASP.NET page as follows

Dim pckg As New DTS.Package
pckg.LoadFromSQLServer(server, usr, pwd,
DTS.DTSSQLServerStorageFlags.DTSSQLStgFlag_Default , , , , pckgName, "")

' execute dts package
pckg.Execute()

, it seems only the truncate table part of the package works. The fox
pro table ends up
looking like an empty table with just the column names.

I gave ASP.NET user complete access to both the directory and the
file, so I don't know
why the data is not getting copied to the file.

I would appreciate your help with this please.

Thank you,

Burak