Post reply

Passing variable from Script task to SSRS

  • November 20, 2009 at 11:28 am

    #143096

    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!

  • November 20, 2009 at 12:03 pm

    #1082409

    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")

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply