This project is read-only.

Sensitive password data not being passed correctly.


I downloaded this module last week and had trouble validating the connection. I discovered this morning that if I change my project parameter sensitive value to false, the connection works, so there is a problem with the passing of the sensitive password. Am I missing something needed to decrypt the key or is this a bug in the module?


Sankeerna wrote Sep 10, 2016 at 10:40 AM


Even I faced the same problem in my task. I resolved it in the following way:
  1. Retain the sensitivity to the project parameter as "True".
  2. Create a local variable to store password. Ex: v_SFTP_Password.
  3. Use script Task to assign the sensitive value to the local variable(v_SFTP_Password).
    Script :
Dts.Variables["User::v_SFTP_Password"].Value = Dts.Variables["$Project::v_SFTP_Password"].GetSensitiveValue();
  1. Use local variable in the SFTP Task for the password.