SQL Server SSIS package performace issue

GUPTA, R. (Rajeev) 1 Reputation point

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.
1,952 questions
No comments
{count} votes

1 answer

Sort by: Oldest
  1. Monalv-MSFT 5,691 Reputation points

    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



    Best Regards,


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