get parameter and use in SSIS from SSRS parameter


  • Hi,
       I am not sure this is the correct place to post this question, but here it is. I am trying to pass some parameters to SSIS from a report using the report parameter, then SSIS will create the datareaderdest and return to the report to use.
       Anyone have any idea, guidance or leads please share it out. Thanks in advance.

    Friday, March 17, 2006 7:31 AM


All replies

  • Not quite sure what you want to to do here. If you want to pass data from SSIS to SSRS then look here in BOL: ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/dtsref9/html/aba8ecb7-0dcf-40d0-a2a8-64da0da94b93.htm



    Friday, March 17, 2006 9:17 AM
  • Hi Jamie,
       what I am trying to do is have a report that has two parameters, lets say param1 and param2. then when user enter the values lets say param1 = 1 and param2 = 5, these two parameters will be passed to SSIS and stored it in the variables I declared there.
       do you know how to go about doing something like that? Thanks in advance.

    Friday, March 17, 2006 9:39 AM
  • You can pass values via the command-line to a package when it executes, but those values will not be "stored" in the package so that they are there next time you execute.



    Friday, March 17, 2006 10:07 AM
  • Hi Jamie,
       can you show me an example of how can I send through command-line or give me some guidelines on where I can find examples for them? Thanks in advance.

    Friday, March 17, 2006 10:12 AM
  • Friday, March 17, 2006 10:17 AM
  • Thanks Jamie,
       I will try that out...

    Friday, March 17, 2006 10:22 AM
  • Hi try using a syntax as follows:


    = "/FILE D:\MyProject\\bin\dtsx\myDtsx.dtsx /SET \Package.Variables[var1];" + Chr(34) + Parameters!Var1.Value + Chr(34) + " /SET \Package.Variables[Var2];" + CStr(Parameters!Var2.Value) + " /SET \Package.Variables[Var3];" + CStr(Parameters!Var3.Value) + " /SET \Package.Variables[Var4];" + CStr(Parameters!Var4.Value)


    If that works fine in VS environment and if it is giving an error once you deployed to ReportManager? Try specifying a TimeOut value for the SSIS DataSource connection within SSRS.

    Thursday, May 10, 2007 11:36 AM