RE: error in scheduled job

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: GG (anonymous_at_discussions.microsoft.com)
Date: 05/10/04 

Date: Mon, 10 May 2004 09:01:04 -0700

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

  • Re: DTS Global Variable problem - type mismatch
    ... But the problem is that the package still fails to run. ... of the properties within the DTS and run it from there then it works. ... > reference to the connection I have in my DTS. ...
    (microsoft.public.sqlserver.dts)
  • Re: Running DTS 2000 Packages via a Job with SQL 2005 installed
    ... All other machines running both clients can open the modified package. ... It seems that if I have a DTS with an FTP step in it, ... DTS NO FTP steps: DTS and Job both run OK ... SQL Server 2000 ...
    (microsoft.public.sqlserver.dts)
  • Exporting to Text file
    ... I am attempting to set up a DTS package to export a view to tab-delimited ... DTS will not generate the field definitions for the text file. ... "Field23" CHARto the view causes it to fail, I could remove "Field22" ... then it fails again. ...
    (microsoft.public.sqlserver.dts)
  • Re: Transactions
    ... >three execute package task to run each of them. ... >that if any one of this package has an error and it fails all the ... Incorporating Transactions in a DTS Package ... global community for SQL Server professionals ...
    (microsoft.public.sqlserver.dts)
  • Re: DTS Process Cube Task
    ... It has a command-line interface -- so you would use a DTS Process Task ... private dimension that contained more than 2 million members. ... occasionally the cube would process, and that was throwing me off. ... DTSRUN of the package from the command-line. ...
    (microsoft.public.sqlserver.olap)