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 derfloh 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
Joined
Aug 10, 2006
Messages
45
Location
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