Share via

ssis package is keep on running in visual studio console

Naresh y 146 Reputation points
2023-09-28T13:29:31.16+00:00

HI Team

i am running one ssis package which is loading the data from source to destation of sql sources with in the same server

when i am running the ssis data flow task , the package is keep on executing but its not reading all the rows from source and package is not completing

oledbsource query rows count : 431149

i tried increasing the buffer size but no use for it

can someone suggest on this buffer size issues?

what changes i can make the buffer size

my source rows count size is : 431149

i gave rows per batch : 10000 ( i tried increase this but it will help )

Maxinsertcommitsize : 2147483647 (max size i gave it)

can some one pls help me to resolve out of this issue

hwz this buffer calculation i didnt understand throughly

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,823 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,578 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. AniyaTang-MSFT 12,446 Reputation points Microsoft Vendor
    2023-09-29T06:35:52.4433333+00:00

    Hi @Naresh y

    For information about the DefaultBufferMaxRows and DefaultBufferSize properties in SSIS, you can refer to this article: https://www.sqlservercentral.com/articles/the-defaultbuffermaxrows-and-defaultbuffersize-properties-in-ssis.

    Best regards,

    Aniya

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.