how to migrate SSIS integration packages from SQL 2008 to 2019

Question

Hi,

i wanted to migrate my sql server from 2008 to SQL 2019, it also has SSIS packages, how can i migrate them from SQL 2008 to SQL 2019

Thanks

Answer 1

Hi @SaikrishnaE

If SQL Server 2008 Integration Services (SSIS) or later is currently installed on your computer, you can upgrade to SQL Server 2019 Integration Services (SSIS).

See the official documentation here.

When you upgrade an instance of SQL Server 2008 (10.0.x) to the current release of SQL Server, your existing SQL Server 2008 Integration Services (SSIS) packages are not automatically upgraded to the package format that the current release SQL Server Integration Services uses.

You can use various methods to upgrade SQL Server 2008 (10.0.x), SQL Server 2008 R2 (10.50.x), SQL Server 2012 (11.x), or SQL Server 2014 (12.x) packages. For some of these methods, the upgrade is only temporary. For others, the upgrade is permanent. The following table describes each of these methods and whether the upgrade is temporary or permanent.

Please check: Upgrade Integration Services Packages

Upgrade Integration Services Packages Using the SSIS Package Upgrade Wizard

Regards，

Zoe Hui

---

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