I have a SSIS package with loop which read the all excel files one by one from specific local folder and copy those files to Azure storage blob. I used file flexible task to copy excel file from my local folder to Archive folder i.e. Azure storage blob. i have total 30 files in my local folder. i want to copy these file one by one in loop but i am getting error for file flexible task the error is Exception of type 'System.OutOfMemoryException' was thrown it through after coping 3 or 4 files. The size of excel file is in KB only.
Waiting for your help.
Thanks in advance.