Connection String to dynamically pass a parameter from SSRS to SSIS

  • Hello,

    I am trying to create a simple test report in SSRS that accepts the user input, then passes it through to an SSIS package as a parameter. I have set up the SSIS package to accept the parameter, which works fine, but I can't figure out what the connection string is meant to look like, for my report parameter to be passed into the package... I know I am close, because I can pass a parameter that isn't dynamic, but I get an error when I change this section of the string, to be dynamic.

    My current string that works is this:

    -f "C:/Downloads/ChangeLog For SSRS.dtsx" -set \Package.Variables[mpan].Value;"1"

    And I want to change that last "1" into something along the lines of Parameters!mpan.Value, but when I do this, the connection string stops functioning.

    The report parameter I am using accepts a string data type.

  • I've solved my problem now - I was using a shared data source, which meant I couldn't use expressions. The solution was to override the datasource used, in my dataset, as this allowed expressions to be used. Syntax was pretty much as I stated before, just needed to put it in the right place 🙂

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply