Good morning everyone.
I have a SSIS job that uploads file to FTP that works fine via SSIS.
I have the protection level set to EncryptSensitiveWithPassWord
I have deployed the package to sql server. when logged into Intergrated Services via SSMS
running the package, entering password it works fine.
But when i setup an agent job and then run that. The package itself runs. but it fails at the FTP task.
what else can i check.
Kind Regards
Rob