0

I have an SSIS c# script task that is downloading a SSRS report using an API, in order to pass in parameters, it uses an object called ParamterValue that has a Value property of type string how would you pass in NULL as the value. I was thinking if it was a SqlParameter you could pass in System.DBNull.Value or maybe even null would also work but it does not for ParameterValue anyone know or have a suggestion what I should try without wanting to change my proc to handle empty string.

This is my code snippet:

public virtual void FleetListing()
{
    ParameterValue param = new ParameterValue()
    {
            Name = "LeaseStatus",
            Value = null //this does not work
    };
    rparams.Add(param);
}

I have never actually laid eyes of the SSRS report nor have any idea where it is so I have a suspicion that the proc behind the report might accept null as a value but the report is configured to not allow nulls - some homework todo.

Glen
  • 802
  • 1
  • 11
  • 27

0 Answers0