Hi,

Has anyone seen this error? I have created a DTS that executes a .bat file,
which looks at a .txt that has all the FTP parameters. The failure codes is
as follows:

Step 'DTSStep_DTSCreateProcessTask_1' failed

Step Error Source: Microsoft Data Transformation Services (DTS) Package
Step Error Description:CreateProcessTask 'DTSTask_DTSCreateProcessTask_1':
Process returned code 2, which does not match the specified SuccessReturnCode
of 0.
Step Error code: 80040496
Step Error Help File:sqldts80.hlp
Step Error Help Context ID:4900

Within the Scheduled job history, this is written:

Executed as user: (Windows Acct). ...script file ftpauto.txt. Transfers
files to and from a computer running an FTP server service (sometimes
called a daemon). Ftp can be used interactively. FTP [-v] [-d] [-i] [-n]
[-g] [-s:filename] [-a] [-A] [-x:sendbuffer] [-r:recvbuffer]
[-b:asyncbuffers] [-w:windowsize] [host] -v Suppresses
display of remote server responses. -n Suppresses auto-login
upon initial connection. -i Turns off interactive prompting
during multiple file transfers. -d
Enables debugging. -g Disables filename globbing (see GLOB
command). -s:filename Specifies a text file containing FTP commands;
the commands will automatically run after FTP starts.
-a Use any local interface when binding data connection. -A
login as anonymous. -x:send sockbuf Overrides the default
SO_SN... Process Exit Code 1. The step failed.

The batch job uses th -s:filename to point to the .txt file that has all the
ftp parameters.

I can logon to the server, open the package and run it. If I schedule the
package it fails. If I try to run the scheduled job it fails. The package
is running under a windows account that has sysadmin on the box and within
SQL Server. It sounds like a permissions issue, but not sure where to look.

Any help appreciated.

Thanks,

Warren

Does this work when you run the package on your PC?

If it does then have a look at this

http://support.microsoft.com/?kbid=269074

It looks as though there may be a syntax error

--


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com


"Warren" <Warren (AT) discussions (DOT) microsoft.com> wrote

Hi Allan,

I can run this from the server. I can login and type out everyline in the
..txt file that has the FTP commands and it works. Also if I open the package
and click execute it works.

Here is the what the .txt file looks like:

CMD
A: (Change directory on the local box)
CD (xxxxxx change directory within the A: drive)
FTP
prompt (to run the job automatically)
open xxx.xxx.xxx.xxx
anonymous
anonymous
cd (xxxxxx. change directory within the FTP site)
mput *.txt
quit
exit

The .bat, .txt are both within the same directory on A:. The .txt files are
within another directory on the A: drive.

Thanks,

Warren

"Allan Mitchell" wrote:

When the job is running on the server though it will not be you running it
(I don't think). The article details which account will be doing the
running of the package dependent on who owns the job (Proxy or Agent).

Can you log on to the server as the account that will be doing the running
and execute the package interactively?


--


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com


"Warren" <Warren (AT) discussions (DOT) microsoft.com> wrote

Dear Allan,

Now when I log in as my acct or the acct running SQL Server I get the last
error that I posted. So I guess there is a DOS syntax error someowhere, but
not sure where? Anyone have any ideas?

Thanks,

Warren


"Allan Mitchell" wrote: