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.
Creation date: 12/1/2022 1:32 PM      Updated: 6/26/2024 5:09 PM
Files   
DataImage44.png
8 KB
DataImage55.png
12 KB