I have a stored procedure that runs a DTS package. The DTS package imports Visual FoxPro data into a SQL server table. Runs fine as long as the FoxPro table is located on my local drive. However, when I modify the connection to point to a copy of the FoxPro table located on a network drive, I get the following error when running the stored procedure:

Error: -2147467259 (80004005); Provider Error: 0 (0)
Error string: [Microsoft][ODBC Visual FoxPro Driver]SourceDB
Error source: Microsoft OLE DB Provider for ODBC Drivers

Running the DTS package directly from within Enterprise Manager works fine -- the error occurs only when running the package from a stored procedure.

Thanks for any help in resolving this problem.

Gary