SSIS error: password was not resolved

I am getting the following error when performing an FTP task in SSIS.

The Password was not allowed

      

What does it mean?

+3


source to share


1 answer


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.

+6


source







All Articles