I'm using SQL Server 2005 Integration Services and Reporting Services. I finally figured out how to use an SSIS package as a data source (in Books Online--you have to modify the .config file) and even got the package to accept variable data from the SSRS data source, but now I can't set a report parameter in the connection string to the package.
Here is the connection string I'm using (that works):
I need to replace the "S0806" with a report parameter, but can't figure out how to do it. If I just type the name of the parameter (ReportCampaignID), the package reads that as a string literal, and finds no results. If I put "@ReportCampaignID", execution fails. If I put "Parameters!ReportCampaignID.Value", execution fails.
Anyone had success with this?
Here is the connection string I'm using (that works):
Code:
-f "C:\Projects\Reporting Services\SSIS_Packages\MultipleDataSource\MultipleDataSource\bin\Package.dtsx" /set \Package.Variables[User::CampaignID].Value;S0806
Anyone had success with this?