|
|
|
SSC Rookie
 
Group: General Forum Members
Last Login: Monday, March 15, 2010 4:33 PM
Points: 45,
Visits: 120
|
|
Hello there,
I have a Script Task with following code
SaveFile(Dts.Variables("varSSRS_URL").Value.ToString() + Dts.Variables("varSSRS_Report").Value.ToString(), Dts.Variables("varSSRS_ExcelReportPath").Value.ToString() + "AwardsTeamPreExpirationReport.xls")
Now I want to be able to pass a variable to the report I am calling on a report server. How can I do this?
Thanks!
|
|
|
|
|
SSC Rookie
Group: General Forum Members
Last Login: Monday, March 15, 2010 4:33 PM
Points: 45,
Visits: 120
|
|
got it ! it was very simple
SaveFile(Dts.Variables("varSSRS_URL").Value.ToString() + Dts.Variables("varSSRS_Report").Value.ToString() + "&awardid=" + Dts.Variables("strAwardID").Value.ToString(), Dts.Variables("varSSRS_ExcelReportPath").Value.ToString() + "ExpirationReport.xls")
|
|
|
|
