January 30, 2009 at 7:16 am
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.
January 30, 2009 at 7:47 am
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