FTP task executes ok in BIDS. Password for FTP server is hard coded in the FTP task .
When I scheduled this package as a job in SSMS it fails because the password blanks out . SQL agent errors out with The login request was denied . Any inputs how to keep the password in FTP within SQL Agent?