We have SSIS package. He has 2 script tasksand a data-flow task. If any of these tasks fails, users receive the task email(through send mail). We recently made changes to the task data-flow. If a packet fails due to any bad data, bad records will be redirected to flat file. we keep it flat filein variableand ship as mail attachment. Now the problem is that we need to attach the file only if it has data. if it has no data, sent mail should not include an attachment. How to do it SSIS? Any help would be greatly appreciated.
thanks shy
source
share