SSIS Import export wizard perform slow in 2019 compare to 2008R2

Sonu Kumar 1 Reputation point

I have an SSIS package (2008R2) already running for a long time on the production with the standard functionality copy data from Oracle to SQL Server.
As I migration step I have to migrate the same package in the 2019 version. Once the migration is done the package performance is not the same as it was in 2008R2.
Alternatively, I have created the new package in 2019 with an import-export wizard functionality and it turned out that the performance is still not the same as it was in 2008R2.

Could you please explain/help why?

Thanks & Regards

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,074 questions
0 comments No comments
{count} votes