Re: DTS Package Fails when scheduled as a job.
- From: "Allan Mitchell" <allan@xxxxxxxxxxxxxxxxxx>
- Date: Tue, 11 Apr 2006 10:07:50 -0400
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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:8B80D029-127F-49AA-88C2-539008BB746A@xxxxxxxxxxxxxxxx
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: Warren
- 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.
- From: Warren
- Re: DTS Package Fails when scheduled as a job.
- Prev by Date: Re: DTS Package Fails when scheduled as a job.
- Next by Date: SSIS - Adding Mappings Programatically
- 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
|
