question

SwatiK-9697 avatar image
0 Votes"
SwatiK-9697 asked Zoehui-MSFT answered

getting memory error issue i.e System.OutOfMemoryException to file flexible task in SSIS

Hi Team,

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.

sql-server-integration-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Zoehui-MSFT avatar image
0 Votes"
Zoehui-MSFT answered

Hi @SwatiK-9697,

System.OutOfMemoryException

The message says that there is not enough memory to execute the package.

Re-open the VS and run the package for a try.

If the error still occurs, you may add more memory to your server or create packages that don't consume that much memory.

Also check sql-server-integration-services-ssis-performance-best-practices to improve the package performance.

Regards,

Zoe


If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.