General information
Forum:
Microsoft SQL Server
Title:
Problem running DTS package from sp
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only