Passing value to multi value parameter from SSIS using Report server webservice


  • Hi
    I am triggering SSRS report from SSIS(Script task). I am passing parameter values from SSIS package.

    So far working fine. Now, I have a report which has 2 parameters. One is single value parameter and the other is multi value parameter.

    No issue assigning value to single value parameter. But how can I pass multi value to multi value parameter?

    My code as below

    ReportExecutionService rs = new ReportExecutionService()
    rs.Credentials = System.Net.CredentialCache.DefaultCredentials;
    rs.Url = _webserviceURL;
    rs.LoadReport(_reportPath, null);

    ParameterValue[] paramval = new ParameterValue[2];

                            paramval[0] = new ParameterValue();
                            paramval[0].Name = "CountryCode";
                            paramval[0].Value = _countryNames;

                            **paramval[1] = new ParameterValue();
                            paramval[1].Name = "BusinessCode";
                            paramval[1].Value = _businessCode;****
                            rs.SetExecutionParameters(paramval, "en-us");

    I am not sure how to pass value to BusinessCode(Multi value parameter)


    Monday, July 14, 2014 10:06 AM


All replies