Re: DTS Package Fails when scheduled as a job.

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




.

Relevant Pages

  • Re: Changing DTS Package Password
    ... though this is pretty poor from Microsoft. ... so the scheduled job has to be edited as well ... > Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... >> I have been asked to move a DTS package between servers and to remove ...
    (microsoft.public.sqlserver.dts)
  • TSLSA-2007-0007 - multi
    ... Affected versions: Trustix Secure Linux 2.2 ... The mod_php module enables the Apache web server to ... The postgresql package includes the client programs and libraries ... SECURITY Fix: Fetchmail does not properly enforce TLS and may ...
    (Bugtraq)
  • Re: remotely call a DTS
    ... Allan Mitchell wrote: ... Denied on something inside the package. ... This worked when I was logged into the server and ran it from my ... but the DTS blows up. ...
    (microsoft.public.sqlserver.dts)
  • Re: sunmanagers Digest, Vol 34, Issue 14
    ... Christopher sent me a link to ftp.cs.tu-berlin.de that has all patches sun ... Subject: SUMMARY: Setting up mail on a Solaris Server ... however I seem to be having issues finding a binary package. ... Problems while installing 108528-29 for Sol8 machine ...
    (SunManagers)
  • Re: DTS Environment Control
    ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. ... When run from the production environment, the production server is accessed and when run from the test environment, the test server is accessed. ... For simple packages it's not too big of deal - but for more complete ones - you can spend an hour carefully changing all your connections. ... I had one solution where we would add an ActiveX script task as the very first step, that would determine what SERVER the package was executing from - and based on that would dynamically change all the connections by looking up the package name and server from a DB. ...
    (microsoft.public.sqlserver.dts)