ERPConnect.InvalidParameterException: The following properties have invalid values: Password
Issue
On executing an SSIS package in VS/SSDT, you receive the following error message:
Error: ERPConnect.InvalidParameterException: The following properties have invalid values: Password
at ERPConnect.R3Connection.CheckLogonProperties(Boolean useLoadBalancing, Boolean useTicket)
at ERPConnect.R3Connection.Open(Boolean useLoadBalancing)
at XtractIS.ConnectionManager.XtractConnectionManager.AcquireConnection(Object txn)
at XtractIS.XtractPipelineComponent.AcquireConnections(Object transaction)
at
Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostAcquireConnections(IDTSManagedComponentWrapper100
wrapper, Object transaction)
The connection test in the connection manager is successful. Running a preview within an Xtract component is also successful. Only package execution fails.
Reason
You are using an Xtract connection manager that does NOT use a Legacy storage mode (connection string) but connection properties.
Within the project or package properties the
ProtectionLevel
property is set to DontSaveSensitive
.Solution
Set the
ProtectionLevel
property to EncryptSensitiveWithUserKey
.
Files | ||
---|---|---|
DataImage44.png 8 KB |
||
DataImage55.png 12 KB |