Hello,

we have SQL Server 2012. I created FTP task in SSIS.

On the connection manager when I try "Test connection" it returns "succeded".

But when I run DTS package I get an error "Error: 0xC002918F at FTP Task, FTP Task: Unable to connect to FTP server using "FTP Connection Manager"."

It seems that SSIS doesn't save the password.

Package level is: Don't Save Sensitive. The password contains "A" and "a". Could there be a problem. Then how to solve it?

You need to add a configuration for the package and include password as an item inside it. Then you will be able to execute the package from outside like through sql server agent job, automated batch job etc.