Hi,

 I am using the following URL to call the report :

        SaveFile("http://devdb1-1/ReportServer?%2fCMD Reports%2fCMD_Collection_Template_Errors&amp;rs:Command=Render&amp;rs:Format=EXCEL&amp;rc:OmitFormulas=true&amp;FileID=266 ", "\outputservpathandfilename")

How do I Make the FileID dynamic in the URL ?
Also the package needs to call ssrs report if there are any errors in the import file. How to accomplish the sending email part ( excel file) from SSIS ?

Thanks,
PB