SSIS Salesforce Connection – INVALID_LOGIN: Invalid username, password, security token; or user locked out

[ZappySys]

Problem

You may receive following Salesforce Connection Error during runtime or after deploying package to Production.

INVALID_LOGIN: Invalid username, password, security token; or user locked out. >> Reason: Password or SecurityToken was empty

Possible Cause

• Your credentials are invalid
• You have specified PackageProtectionLevel to DoNotSaveSensitive but you have not supplied Password / SecurityToken properties via expression or Parameters during runtime.

Solution

If you have set PackageProtectionLevel = DoNotSaveSensitive  then make sure you supply Password / SecurityToken at runtime using any of following parameterization methods.

• Use Package Parameters to configure Password / SecurityToken
• Expression Password / SecurityToken properties
• Use Config file to configure Full ConnectionString or Configure Password / SecurityToken Properties of Salesforce connection

 

[Author]

Posts