kl25:

Thanks for your reply.

The value of the variable ExceptionReportPath is C:\Reports\ and the expression is set to C:\Temp\. So during runtime I'd like the excel file to get produced in C:\Temp with a datetime stamp. However, after running the package the data from the oledbsource loads the data into C:\Reports\ExceptionReport.xls.

I verified point #2 that the expression of the ExcelFilePath is set to @[User:ExceptionReportName].

Phil:

Thanks for your reply 🙂

Is there a best practice in this? I'd like to figure out what I'm doing wrong as (to me) it seems a simpler approach. But if I can't get it I'll try out using a file task.