mail task

how to attach a xls file that will be created at run time using mail task. I get a file does not exist error if the file is not there.

If the file is not there, then obviously you would expect the task to fail.

If your are just having issues because at the start of execution the file is not there, but it will exist by the time the mail task actually runs, use the DelayValidation property. This will stop the mail task validating at the beginning of package execution, it will only validate immediately prior to the task execution, by which time you should have written the file.