job faild
-
Lo to all,
I create a dts that sending a file with cmdShell to an ftp site when im running the dts not in a job mode its work fine, But when i create a job the process faild. Im getting the error:
Date 31/01/2005 17:01:39
Log Job History (Test)
Job Name Test
Step ID 1
Step Name Test
Message Executed as user: ENTERPRISE\iladmin. ...************************ **************************** C:\Program Files\Common Files\SYSTEM\MSMAPI\1033>Echo File Transfer about to start File Transfer about to start C:\Program Files\Common Files\SYSTEM\MSMAPI\1033>Echo **************************** **************************** C:\Program Files\Common Files\SYSTEM\MSMAPI\1033>ftp -s:t:\Customised\Database\PFW\Util\$ConData.scr Error opening script file t:\Customised\Database\PFW\Util\$ConData.scr. 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 du... Process Exit Code 1. The step failed.
-
Does the userID used on the jon have access to the T drive or the file? How about creating a batch/cmd file and call these file from the dts package.
-
The user has a full permission on T drive.
This is waht the job do calling dts and the dts running the cmd file
regards ,lital.
-
I would double check the script which is being called in the ftp process, it's not able to access the file, which, if the permissions are fine, just means that the file location could be incorrect.
-
this is the cmd file contents:
ftp -s:t:\Customised\Database\PFW\Util\$ConData.scr
this is the scr file contents:
open 10.22.55.55
asddd
ftpee
cd panel
pwd
put t:\Customised\Database\PFW\Util\ILpanelcontrol
quit
from the dts the process running fine (same user)
-
It's the scr file which is the problem, the ftp process cannot locate it. (Error opening script file t:\Customised\Database\PFW\Util\$ConData.scr. )
Have you tried running the ftp command directly on the server to ensure that it can connect without issue?
(open up a command prompt and just run ftp -s:t:\Customised\Database\PFW\Util\$ConData.scr 
-
its working file from the cmd
-
From within QA, if you run
exec master..xp_cmdshell 'dir t:\Customised\Database\PFW\Util\$ConData.scr'
What results do you get?
-
im getting the error:
"the system cannot find the path speciefied"
-
This would indicate that the sql server service accounts either do not have access to the drive/file, or that the file does not in fact exist.
-
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply