I’m trying to upgrade some packages from SSIS 2014 to SSIS 2022. I can’t find any documentation that says I can’t do this, but it’s not working.
I open the project in VS 2022 with the SSIS extension. I’m using the Feb 13 release (version 0.3). I right click on the SSIS Packages node and choose Upgrade All Packages. I get through the upgrade wizard successfully, but it doesn’t recognize any of the tasks after the upgrade. These are not custom tasks, mostly just Execute SQL tasks and data flows.
The error is: Cannot create a task from XML for task “Evaluate Batch”, type “SSIS.Replacement Task… due to error 0x80070057 “The parameter is incorrect”.
Is there a way to work around this? Do I need to upgrade to some intermediate version first?