I put a Script Component between the oledb source and excel destination to popup the value of ExceptionReportName. The value was C:\Reports\ExceptionReport.xls. I was expecting an excel file to be in C:\Temp\ExceptionReport_201304011029. For some reason, during runtime the expression of ExceptionReportName isn't being used.

The intention of ExceptionReport Path is to be used as a parameter for the different environments (dev, uat, prod). So for example, the value of ExceptionReportPath in dev will be \\Serverdev\Reports\. After the package runs, there should be a file \\Serverdev\Reports\ExceptionReport_201304011031.xls.

Hope this clarifies what I'm trying to do.