** Update **
Lesson learned the hard way:
Always set current dir to JUSTPATH( _vfp.ServerName ) whether ya think ya need it or not...

Thanks Jim S.
*************


Hi All,

I've been losing sleep over what I'd imagine should be a fairly simple and common task. This has got to be something simple that I'm overlooking...


We're trying to execute a simple VFP 8 SP 1 exe from inside a SQL Server 2000 DTS package using DTSRUN and it's refusing to launch. At this point for troubleshooting, it won't even work as the only part of a single step DTS package, it being the only step.

We've gone through the permissions (even tried using a Windows/SQL admin login) and the DBA has even been on the phone with MS Support. I loaded it up with STRTOFILE() calls to write out progress and log errors, and it doesn't even make it to the first line of the program.

The exe is just a single prg that opens a table, checks for a certain field, ALTER TABLE if it doesn't find it and then closes the table. Nothing fancy.

It runs fine if we launch the exe manually or run the DTS package manually from the Enterprise Manager.

Is there something special in the VFP code that I need to do so this works from within a DTS package?



Thanks,

- Brian