Migration of SSIS packages from sql server 2016 to sql server 2022

Question

Migration of SSIS packages from sql server 2016 to sql server 2022

Vishwanath C R 25

Hi ,

we are trying to migrate ssis packages from sql server 2016 to sql server 2022 , we are not able to migrate ssis packages completely , there are some errors which are blocking our migration . please guide the steps to migrate ssis packages .

Accepted answer

1 additional answer

Your answer

Answer 1

ZoeHui-MSFT 41,491

Hi @Vishwanath C R,

Are you using VS2022 to migrate SSIS package from 2016 to 2019?

SQL Server Integration Services Projects 2022 does not have a GA version temporarily.

There are some known issues under test, you may wait for the GA version and keep the SSIS2016 or migrate to SQL Server2019 temporarily.

Regards，

Zoe Hui

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

Vishwanath C R 25 Reputation points

2023-06-13T05:29:47.6033333+00:00

Are you using VS2022 to migrate SSIS package from 2016 to 2019?

Hi @ZoeHui-MSFT

No, we are using vs2019, but we just wanted to migrate SSIS packages from SQL SERVER 2016 to SQL SERVER 2022if this can be done, could you please suggest the way.

Answer 2

Olaf Helper 47,436

there are some errors which are blocking our migration

And what for errors do you get; we can't guess them. Please post the complete error messages.

please guide the steps to migrate ssis packages .

Open the SSIS project in the latest SSDT version, change project property "TargetServerVersion" to 2022, compile the project and may deploy it; that's all.

Vishwanath C R 25 Reputation points

2023-06-12T09:50:06.1266667+00:00
hi, below are the list of errors i am getting ,

the binary code for the script is not found , please open the script in the designer by clicking edit script button and make sure it builds successfully.

2.Error:CS1518 -expected class deligate ,enum,interface or struct ScriptMain.cs

3.Failed to compiled scripts contained in the package .open the pacakge in SSIS Designer and resolve the compilation error .

these are the errors we are facing sir .
ZoeHui-MSFT 41,491 Reputation points

2023-06-13T07:23:54.34+00:00

Hi @Vishwanath C R,

Script tasks require recompilation after migrate, could you please edit the script and re-build it for a try?

Share via

Migration of SSIS packages from sql server 2016 to sql server 2022

1 additional answer

Your answer