Problems Between DTS Packages And Stored Procedures

I have a DTS package that I wanted to call from a Coldfusion page. Going through some searches, I found this page which uses three seperate stored procedures to run a DTS packages.

All seems fine and dandy until nothing changes after running the package with coldfusion. I start dumping the cfstoredproc variable, and it turns out that the DTS fails every time it gets to the Excel file. Looking at the logs, the reason is that the JET Database Engine failed creating the file. This doesn't make sense, as the DTS runs fine from within Enterprise Manager.

Is there something in the connection between the stored procedure and the DTS that would cause a problem like this? Might calling the DTS from a stored procedure change the full path that the file looks at?

EDIT:

Here's the exact error I'm given from the DTS logs:

Code:



Step Error Source: Microsoft JET Database Engine
Step Error Description:Failure creating file.
Step Error code: 80004005
Step Error Help File:
Step Error Help Context ID:5003436