Calling SQL Server Reporting Services Packages (SSRS) reports in SQL Server Integration Services packages (SSIS) can be tricky.  Especially when parameters are involved.  Most people have created sql jobs to run reports but the tracking of these associations and their cryptic names when you have a large amount of reports can be time consuming and almost impossible.  Below is a way in which you can accomplish about any report call withing a script task.  You can specify where to send the output for further report processing as well.  Any Questions... use the comments.<!--more-->
<p class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: &quot;Courier New&quot;; color: blue; font-size: 10pt;">Imports</span><span style="font-family: &quot;Courier New&quot;; font-size: 10pt;"> System</span></p>
<p class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: &quot;Courier New&quot;; color: blue; font-size: 10pt;">Imports</span><span style="font-family: &quot;Courier New&quot;; font-size: 10pt;"> System.Data</span></p>
<p class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: &quot;Courier New&quot;; color: blue; font-size: 10pt;">Imports</span><span style="font-family: &quot;Courier New&quot;; font-size: 10pt;"> System.Math</span></p>
<p class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: &quot;Courier New&quot;; color: blue; font-size: 10pt;">Imports</span><span style="font-family: &quot;Courier New&quot;; font-size: 10pt;"> Microsoft.SqlServer.Dts.Runtime</span></p>
<p class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: &quot;Courier New&quot;; font-size: 10pt;"> </span></p>
<p class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: &quot;Courier New&quot;; color: blue; font-size: 10pt;">Public</span><span style="font-family: &quot;Courier New&quot;; font-size: 10pt;"> <span style="color: blue;">Class</span> ScriptMain</span></p>
<p class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: &quot;Courier New&quot;; font-size: 10pt;"> </span></p>
<p class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: &quot;Courier New&quot;; font-size: 10pt;"> </span></p>
<p class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: &quot;Courier New&quot;; font-size: 10pt;">    <span style="color: blue;">Public</span> <span style="color: blue;">Sub</span> Main()</span></p>
<p class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: &quot;Courier New&quot;; font-size: 10pt;">        SaveFile(<span style="color: maroon;">"<a href="http://localhost/ReportServer?%2fparameterTestReport%2ftest1&amp;rs:Command=Render&amp;rs:Format=PDF&amp;testparam=xxxxxxx"><span style="color: #0000ff;">http://servername/ReportServer?%2fparameterTestReport%2ftest1&amp;rs:Command=Render&amp;rs:Format=PDF&amp;testparam=xxxxxxx</span></a>"</span>, <span style="color: maroon;">"<a href="//\outputservpath"><span style="color: #0000ff;">\outputservpath</span></a>andfilename"</span>)</span></p>
<p class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: &quot;Courier New&quot;; font-size: 10pt;">        Dts.TaskResult = Dts.Results.Success</span></p>
<p class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: &quot;Courier New&quot;; font-size: 10pt;">    <span style="color: blue;">End</span> <span style="color: blue;">Sub</span></span></p>
<p class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: &quot;Courier New&quot;; color: blue; font-size: 10pt;"> </span></p>
<p class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: &quot;Courier New&quot;; font-size: 10pt;">    <span style="color: blue;">Protected</span> <span style="color: blue;">Sub</span> SaveFile(<span style="color: blue;">ByVal</span> url <span style="color: blue;">As</span> <span style="color: blue;">String</span>, <span style="color: blue;">ByVal</span> localpath <span style="color: blue;">As</span> <span style="color: blue;">String</span>)</span></p>
<p class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: &quot;Courier New&quot;; font-size: 10pt;">        <span style="color: blue;">Dim</span> loRequest <span style="color: blue;">As</span> System.Net.HttpWebRequest</span></p>
<p class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: &quot;Courier New&quot;; font-size: 10pt;">        <span style="color: blue;">Dim</span> loResponse <span style="color: blue;">As</span> System.Net.HttpWebResponse</span></p>
<p class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: &quot;Courier New&quot;; font-size: 10pt;">        <span style="color: blue;">Dim</span> loResponseStream <span style="color: blue;">As</span> System.IO.Stream</span></p>
<p class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: &quot;Courier New&quot;; font-size: 10pt;">        <span style="color: blue;">Dim</span> loFileStream <span style="color: blue;">As</span> <span style="color: blue;">New</span> System.IO.FileStream(localpath, System.IO.FileMode.Create, System.IO.FileAccess.Write)</span></p>
<p class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: &quot;Courier New&quot;; font-size: 10pt;">        <span style="color: blue;">Dim</span> laBytes(256) <span style="color: blue;">As</span> <span style="color: blue;">Byte</span></span></p>
<p class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: &quot;Courier New&quot;; font-size: 10pt;">        <span style="color: blue;">Dim</span> liCount <span style="color: blue;">As</span> <span style="color: blue;">Integer</span> = 1</span></p>
<p class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: &quot;Courier New&quot;; font-size: 10pt;"> </span></p>
<p class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: &quot;Courier New&quot;; font-size: 10pt;">        loRequest = <span style="color: blue;">CType</span>(System.Net.WebRequest.Create(url), System.Net.HttpWebRequest)</span></p>
<p class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: &quot;Courier New&quot;; font-size: 10pt;">        loRequest.Credentials = System.Net.CredentialCache.DefaultCredentials</span></p>
<p class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: &quot;Courier New&quot;; font-size: 10pt;">        loRequest.ImpersonationLevel = Security.Principal.TokenImpersonationLevel.Delegation</span></p>
<p class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: &quot;Courier New&quot;; font-size: 10pt;">        loRequest.Timeout = 1000 * 60 * 15 <span style="color: green;">'15 minute timeout... you may need to increase for some large reports.</span></span></p>
<p class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: &quot;Courier New&quot;; font-size: 10pt;">        loRequest.Method = <span style="color: maroon;">"GET"</span></span></p>
<p class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: &quot;Courier New&quot;; font-size: 10pt;">        loResponse = <span style="color: blue;">CType</span>(loRequest.GetResponse, System.Net.HttpWebResponse)</span></p>
<p class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: &quot;Courier New&quot;; font-size: 10pt;">        loResponseStream = loResponse.GetResponseStream</span></p>
<p class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: &quot;Courier New&quot;; font-size: 10pt;">        <span style="color: blue;">Do</span> <span style="color: blue;">While</span> liCount &gt; 0</span></p>
<p class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: &quot;Courier New&quot;; font-size: 10pt;">            liCount = loResponseStream.Read(laBytes, 0, 256)</span></p>
<p class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: &quot;Courier New&quot;; font-size: 10pt;">            loFileStream.Write(laBytes, 0, liCount)</span></p>
<p class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: &quot;Courier New&quot;; font-size: 10pt;">        <span style="color: blue;">Loop</span></span></p>
<p class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: &quot;Courier New&quot;; font-size: 10pt;">        loFileStream.Flush()</span></p>
<p class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: &quot;Courier New&quot;; font-size: 10pt;">        loFileStream.Close()</span></p>
<p class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: &quot;Courier New&quot;; font-size: 10pt;">        System.Threading.Thread.Sleep(2000)</span></p>
<p class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: &quot;Courier New&quot;; font-size: 10pt;">    <span style="color: blue;">End</span> <span style="color: blue;">Sub</span></span></p>
<p class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: &quot;Courier New&quot;; color: blue; font-size: 10pt;"> </span></p>
<p class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: &quot;Courier New&quot;; color: blue; font-size: 10pt;"> </span></p>
<p class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: &quot;Courier New&quot;; color: blue; font-size: 10pt;">End</span><span style="font-family: &quot;Courier New&quot;; font-size: 10pt;"> <span style="color: blue;">Class</span></span></p>