A Microsoft platform for building enterprise-level data integration and data transformations solutions.
SSIS Import export wizard perform slow in 2019 compare to 2008R2
Sonu Kumar
1
Reputation point
Hi,
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
Sonu
SQL Server Integration Services
SQL Server Integration Services
Sign in to answer