Re: DTS Package Fails when scheduled as a job.
- From: Warren <Warren@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 11 Apr 2006 06:41:02 -0700
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:
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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:AA0F8E94-E8D4-4B70-98B6-9A0D5F4197E5@xxxxxxxxxxxxxxxx
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
ection. -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
- Follow-Ups:
- Re: DTS Package Fails when scheduled as a job.
- From: Allan Mitchell
- Re: DTS Package Fails when scheduled as a job.
- References:
- Re: DTS Package Fails when scheduled as a job.
- From: Allan Mitchell
- Re: DTS Package Fails when scheduled as a job.
- Prev by Date: Re: DTS Package Fails when scheduled as a job.
- Next by Date: Re: DTS Package Fails when scheduled as a job.
- Previous by thread: Re: DTS Package Fails when scheduled as a job.
- Next by thread: Re: DTS Package Fails when scheduled as a job.
- Index(es):
Relevant Pages
|
Loading
