Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Passing a report parameter into an SSIS package

Status
Not open for further replies.

SQLHacker

MIS
Aug 10, 2006
45
US
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):
Code:
-f "C:\Projects\Reporting Services\SSIS_Packages\MultipleDataSource\MultipleDataSource\bin\Package.dtsx" /set \Package.Variables[User::CampaignID].Value;S0806
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?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top