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\SVMcom Data\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

Have a look at this

http://support.microsoft.com/?kbid=26907

Can you have a look at my post regarding the Cmdexec DTS -- Fails

Thank

----- Dan wrote: ----

I'm using SS2000 SP3. I have a dts package that runs fine when directl
executed. However, when I schedule it, I get errors. When scheduled, it wil
fail on the first step which is to download a file from the ftp server. I'v
tried two different ways to download the file

When I try to use an Execute Process Task to run a batch file, I get thi
error
Executed as user: ARCHER\Administrator. ... the ftp sit
C:\WINNT\system32>ftp -i -s:svmcomftp.txt Error opening script fil
svmcomftp.txt. Transfers files to and from a computer running an FT
server service (sometimes called a daemon). Ftp can be used interactively

Here is the batch file
ftp -i -s:svmcomftp.tx

and the svmcomftp.txt file
open ftp.archeo.co
jimb
arist
cd terminix\telecente
lcd G:\Clients\Terminix\VESTA\database\hotleads\SVMcom Data\sourc
mget mission_leads_incoming.cs
by

The other approach I tried was running the same files from an ActiveX scrip
task. Here is the code
Function Main(
Set ws = CreateObject("Wscript.Shell"
ws.run """svmcomftp.bat""", 0, Tru
Set ws = nothin
Main = DTSTaskExecResult_Succes
End Functio

The error I get using this approach is
Executed as user: ARCHER\Administrator. ...: DTSStep_DTSActiveScriptTask_
DTSRun OnError: DTSStep_DTSActiveScriptTask_1, Error = -214722048
(800403FE) Error string: Error Code: 0 Error Source= Microsof
VBScript runtime error Error Description: Permission denied
'CreateObject' Error on Line 1 Error source: Microsoft Dat
Transformation Services (DTS) Packag

When I try to run these packages, I am logged in through terminal service
as administrator. The packages are owned by the administrator. And th
packages run fine using either approach if I execute the package withou
scheduling it

Any ideas

Thanks

Da

In addition to the previous post, what account are you using to connect to the ftp server? Does this account have permissions on the ftp server?

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 (AT) discussions (DOT) microsoft.com> wrote