I have an issue with ssis package where foreach loop has sequence of dataflow tasks, flatfile as destination. in all dataflow tasks flatfile destination pointing to same file, for single iteration. foreach loop requirement. as shown in picture, very first dataflow task success, where as second dataflow getting failed in flat file destination step, because the file not released from first dataflow task even it is complete. Please help me for the same.
Thanks, Sharif.