I have a DTS that converts a SQL Server table to VFP. The DTS runs fine when I run it from SQL Server Enterprise Manager. However, when running the DTS from my Prg, it logs that it cannot open my DBC.

I checked the DBC name and location the DTS logged, and both are correct.

Also, the DTS always fails if I have Cdx indexes.

Any thoughts or experience with these issues?
=============================================
Here's the code snippet:

...some pre-processing stuff, after which I close the tables and database
CLOSE DATABASE

loDTSPackage=CREATEOBJECT('dts.package')
loDTSPackageName=loDTSPackage.LoadFromStorageFile(curdir()+"ConsultWare - AS400 Facility Address Parsing.dts","")
loDTSPackage.Execute
...some post-processing stuff