1
Vote

Exception when no variables selected

description

If no variables are selected, the following error occurs: Object reference not set to an instance of an object.

This is due to UpdateSsisVariables being called inside the Execute method of the PowerShellScriptTask class. This can be avoided by checking the variable count beforehand, as shown below:
if (this.ReadWriteVariables.Count > 0)
    this.UpdateSsisVariables(variableDispenser, rs);
Also, when in Release configuration the compilation fails due to the DebugOnExecute member not being surrounded by an #if directive.

comments