It sounds like account SQL Server is running under doesn't have access to that network drive.

>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