Re: error in scheduled job

From: Dan (ddonahue_at_archermalmo.com)
Date: 05/10/04 

Date: Mon, 10 May 2004 11:48:56 -0500

I figured it out. I had to put the full path to the .txt in the .bat file.
then it worked.

Thanks for the response.

Dan

"GG" <anonymous@discussions.microsoft.com> wrote in message
news:F2014C0C-8931-4E51-AF39-B90ADC8C10BC@microsoft.com...
> Have a look at this:
>
> http://support.microsoft.com/?kbid=269074
>
> Can you have a look at my post regarding the Cmdexec DTS -- Fails?
>
> Thanks
>
> ----- Dan wrote: -----
>
> I'm using SS2000 SP3. I have a dts package that runs fine when
directly
> executed. However, when I schedule it, I get errors. When scheduled,
it will
> fail on the first step which is to download a file from the ftp
server. I've
> tried two different ways to download the file.
>
> When I try to use an Execute Process Task to run a batch file, I get
this
> error:
> Executed as user: ARCHER\Administrator. ... the ftp site
> C:\WINNT\system32>ftp -i -s:svmcomftp.txt Error opening script file
> svmcomftp.txt. Transfers files to and from a computer running an
FTP
> server service (sometimes called a daemon). Ftp can be used
interactively.
>
> Here is the batch file:
> ftp -i -s:svmcomftp.txt
>
> and the svmcomftp.txt file:
> open ftp.archeo.com
> jimbo
> aristy
> cd terminix\telecenter
> lcd G:\Clients\Terminix\VESTA\database\hotleads\SVMcomData\source
> mget mission_leads_incoming.csv
> bye
>
> The other approach I tried was running the same files from an ActiveX
script
> task. Here is the code:
> Function Main()
> Set ws = CreateObject("Wscript.Shell")
> ws.run """svmcomftp.bat""", 0, True
> Set ws = nothing
> Main = DTSTaskExecResult_Success
> End Function
>
> The error I get using this approach is:
> Executed as user: ARCHER\Administrator. ...:
DTSStep_DTSActiveScriptTask_1
> DTSRun OnError: DTSStep_DTSActiveScriptTask_1, Error = -2147220482
> (800403FE) Error string: Error Code: 0 Error Source=
Microsoft
> VBScript runtime error Error Description: Permission denied:
> 'CreateObject' Error on Line 1 Error source: Microsoft
Data
> Transformation Services (DTS) Package
>
> When I try to run these packages, I am logged in through terminal
services
> as administrator. The packages are owned by the administrator. And
the
> packages run fine using either approach if I execute the package
without
> scheduling it.
>
> Any ideas?
>
> Thanks,
>
> Dan
>
>
>

Relevant Pages

  • [OpenPKG-SA-2002.015] OpenPKG Security Advisory (tetex)
    ... Vulnerability: remote command execution ... Affected Releases: Affected Packages: Corrected Packages: ... attacker to execute arbitrary commands via cleverly crafted DVI files. ... fetch it from the OpenPKG FTP service or a mirror location. ...
    (Bugtraq)
  • [SLE] Suse 8.2 install error, libc.so.6 TLS error...
    ... I'm doing a network install of 8.2(hfs or ftp) and get the following ... error on about 20% of the packages... ... Dan ...
    (SuSE)
  • Re: DTS Error - Step 1
    ... The SQLAdmin account doesn't need FTP access. ... The packages uses the FTP ... When I use DTSRUN to execute the package it works fine, ...
    (microsoft.public.sqlserver.dts)
  • Re: Building 2.6.10 kernel for Debian and ncurses
    ... >> packages which are already installed and work fine. ... >sourceforge.net for available chroot tools for SSH. ... account not unlike the concept of anonymous login for ftp. ... although the end users have to enter user IDs and passwords ...
    (comp.os.linux.setup)
  • Re: Cannot execute DTS package
    ... > "Hermit Dave" wrote in message ... >> Whats happening is that it is trying to execute the Query with context ... >>> executing DTS packages from the ASP.NET: ... >>> String ServerPassword, DTSSQLServerStorageFlags Flags, String ...
    (microsoft.public.dotnet.framework.aspnet)