Share via

Client extracts are taking long time

ASHISH SINGH 21 Reputation points
2021-02-16T16:23:58.407+00:00

Hi, In a business requirement, I'm giving an extract in text file from sql view (combination of multiple tables). This vies has more than 200 million lines with 150+ columns. I'm using using SSIS (OLEDB as source and flat file connection in destination) to make it but process is taking too much time to build and if process runs into memory issue in middle then it all starts again from beginning. More once it gets done need to make it zip with encryption that's also taking longer to done.

Please suggest what should i check or correct to make this process faster !

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

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. EchoLiu-MSFT 14,591 Reputation points
    2021-02-17T07:35:55.013+00:00

    Hi @ASHISH SINGH ,

    You can see all the moving parts in the last tab (Execution Results/Progress), and take a look at timing. It'll help you see what in particular is taking the most time.

    If you have any question, please feel free to let me know.

    Regards
    Echo

    If the answer is helpful, please click "Accept Answer" and upvote it.
    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

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.