SQL Server SSIS package performace issue

GUPTA, R. (Rajeev) 1 Reputation point
2020-09-04T00:53:56.307+00:00

Hello All,

Using SQL Server SSIS package Trying to export MS SQL table data into oracle table it is taking 1hr for 50 lac row (Table Name - EMP, Column ID, and Name)

For the same table SSIS IMPORT taking only 1 min.

I need help or suggestion how to check why it's taking this much time and how to reduce.

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,453 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Monalv-MSFT 5,891 Reputation points
    2020-09-04T02:32:04.26+00:00

    Hi GUPTA,

    Please set properties in the control flow to make the ssis packages have good performance.

    We can create SSIS logging to see the execution information.

    Or we can click Progress to see the execution information.

    Please refer to the following links and pictures:

    Integration Services Performance Best Practices – Data Flow Optimization

    Integration Services (SSIS) Logging

    22574-tasksincontrolflow.png

    22643-progress.png

    Best Regards,
    Mona

    ----------

    If the response is helpful, please click "Accept Answer" and upvote it.