SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,564 questions
SSIS Import export wizard perform slow in 2019 compare to 2008R2
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(16, 75%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
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
Sign in to answer