question

Zaran-3086 avatar image
0 Votes"
Zaran-3086 asked ZoeHui-MSFT commented

How to Pass multiple choice value parameter from SSRS to SSIS

Hi

Could you please help me How to Pass multiple choice value parameter from SSRS to SSIS?
For e.g. I have a report with Name parameter( this parameter is check box parameter), if I select 3 names , how can I pass 3 names through Script Task in SSIS?

Thanks

sql-server-integration-services
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

How to Pass multiple choice value parameter from SSRS to SSIS?

Where do you see any relation/combination between SSRS and SSIS? With SSRS you can't do anything in direction to SSIS.



0 Votes 0 ·

Sorry my bad question.

I have SSRS report with Checkbox parameter( multiple choice), and I want to automated sending report through SSIS.
for one parameter with one value I did like below, but I don't know how to do it for multiple vale from one parameter(Name is my parameter )
Public Sub Main()
Dim Name As String=Dts.Variables("User::vName").value.ToString

End Sub

Public GenerateReport1(Name As String)

Dim Parameters(2) As ParameterValue
parameters(0)=New ParameterValue()
parameters(0).Name="Name"
parameters(0).value=Name
End Sub

0 Votes 0 ·

1 Answer

ZoeHui-MSFT avatar image
0 Votes"
ZoeHui-MSFT answered ZoeHui-MSFT commented

Hi @Zaran-3086,

Let me double check that you want to pass the multiple value parameter from SSRS to SSIS?

Do you want to execute the SSRS report or do any other action?

You may refer execute-a-sql-server-reporting-services-report-from-integration-services-package to see if it is helpful.

If you want to pass multi value parameter to SSRS report from SSIS.

You may refer passing-multi-value-parameter-to-ssrs-report-from-ssis.

Regards,

Zoe


If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues October


· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi Zoehui-MSFT,

Thanks for your help.

You referred me "passing-multi-value-parameter-to-ssrs-report-from-ssis", and it is exactly that I need.
Could you please help me about the "Call SetExecutionParameters with that array"?
I started to learn recently, and new in C# code

Thanks

0 Votes 0 ·