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

Swati K 1 Reputation point
2022-05-05T15:09:14.663+00:00

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
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,459 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 33,296 Reputation points
    2022-05-06T05:54:15.147+00:00

    Hi @Swati K ,

    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.

    0 comments