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.