January 6, 2009 at 12:18 am
I have scheduled a job in Sql server that executes SSIS package on daily basis. The SSIS package contains a FTP task that downlaods files from a FTP location to a local machine. The FTP site has login credentials with some id and password.
When i execute the package, it runs fine and data files are copied from the FTP site to the local machine. But while executing the job, it gives an error. The error message: 'An error occurred in the requested FTP operation. Detailed error description: The password was not allowed'.
Any suggestions to rectify the error.
Thanks
January 6, 2009 at 12:30 am
Check the credentials and findout job owner is having access to FTP.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
January 6, 2009 at 1:06 am
The credentials are correct and the access is also there.
January 6, 2009 at 1:16 am
Check the credentials under which the SQL Server Agent is running. Also, check in the job properties that you have specified SQL server Agent credentails to be used to execute the job.
- Vikas Bindra
Sr. Software Engineer - BI
-Vikas Bindra
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply