I have a DTS job scheduled to run daily. This package has been running
smoothly for a year. A couple weeks ago it began failing with this error
(username has been x'd out, no changes have been made to the users
permissions either in SQL or on the server):

Executed as user: xxxxxxxx\xxxx_xxxxxx. DTSRun: Loading... Error:
-2147467259 (80004005); Provider Error: 0 (0) Error string:
Unspecified error Error source: Microsoft Data Transformation
Services (DTS) Package Help file: sqldts80.hlp Help context: 713.
Process Exit Code 1. The step failed.

Now, when I execute the DTS package from Enterprise Manager it works fine.
My admin folks say there were no updates to the server. I've narrowed this
down to the first task which is an FTP task that downloads a file we use for
updates. When I remove this task the package runs smoothly. I've created a
new DTS package with only the FTP Task and I get the same error. I've tried
running it as different users with admin permissions on the server and still
the error. Does anyone know where to go from here?

btw: When I run the FTP as a process task using a script file it works fine.

--
Zip