Remember, when you manually run it (from the em), it will run the package on your local machine, meaning, it will use the odbc drivers and your user accuont on your local machine to access the data, not the server account. When you envoke the package from a sp its using the server to run the package. So, make sure the server itself has access to the vfp data.

Eric Stephani
MIO Database Administrator


>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