memorandum

Note what you noticed about SQL Server.

SSIS (SQL Server Integration Services)

FTP Tasks and FTP Connection Manager Fail to Authenticate Password When Run

It seems to occur when the "ProtectionLevel" of the Integration Services package file (.dtsx) is set to "DontSaveSensitive". Since the password is a security-related parameter, if you save the package file unencrypted, it is likely because you are not storing the password.

To avoid this, you must set the ProtectionLevel of the package to something other than DontSaveSensitive, or set a password to the "ServerPassword" of the FTP Connection Manager at runtime. Use a "script task" to set a password at run time.