SSIS error: password was not resolved
SSIS stores secret data (such as passwords) encrypted based on the value of a package property ProtectionLevel
. This is EncryptSensitiveWithUserKey
the default (this means that the encrypted part can be read with the same user account that created the package). Learn more about Access Control on TechNet
You can set this property as EncryptSensitiveWithPassword
and then set the property PackagePassword
. You can execute the package using the DTExec utility with a parameter /De {password}
. (You can edit the properties of a package by right-clicking an empty area in the package control flow, then choosing Properties).
Another way is to create a simple Script Task
(before FTP Task
) that sets the value at runtime. The following code sets the password property for the connection FTPConnectionName
.
C # code
ConnectionManager FTPConn;
FTPConn = Dts.Connections["FTPConnectionName"];
FTPConn.Properties["ServerPassword"].SetValue(FTPConn, "YourPassword");
Dts.TaskResult = (int)ScriptResults.Success;
Add this code to the destination of the script (Main ()) task. (Optionally, you can add a string variable to your package and add it to the read-only variables of the script task and use it ( Dts.Variables["FTPPassword"].Value
) to set the password.
source to share