Errors upgrading SSIS 2014 packages to 2022 using the SSIS 2022 VSIX in Visual Studio 2022.

Meagan Longoria 26 Reputation points MVP
2023-03-09T17:08:09.4166667+00:00

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?

Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,512 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,437 questions
0 comments No comments
{count} vote

3 answers

Sort by: Most helpful
  1. Yitzhak Khabinsky 24,831 Reputation points
    2023-03-09T18:59:34.4166667+00:00

    Hi @Meagan Longoria,

    The SQL Server Integration Services Projects extension for VS2022 v.0.3 is a preview. It has lots of bugs and limitations.

    I would suggest staying with VS2019, and its SQL Server Integration Services Projects extension v.4.4. It is a GA release, and it supports SSIS 2022.

    Please see below.

    SSIS - TargetServerVersion

    1 person found this answer helpful.
    0 comments No comments

  2. Jim R. Donkersgoed 5 Reputation points
    2023-06-08T13:37:03.8266667+00:00

    I was getting a an error "SSIS.ReplacementTask" is not registered on this computer." Eventually found that the execute sql task was my issue. Tried installing SSDT v1.0 without success. I installed SQL Server 2014 developer edition with service pack 3 and my issues went away. I don't think those tasks are included with the 2022 SSDT pack v1.0.

    Hope this helps someone,

    Jim

    1 person found this answer helpful.

  3. ZoeHui-MSFT 32,081 Reputation points
    2023-03-10T02:24:05.8033333+00:00

    Hi @Meagan Longoria,

    Full agree with @Yitzhak Khabinsky's opinion that SSIS2022 do not have a GA version now.

    I'd like suggest that you may wait for the GA version or use VS2019 temporarily.

    Regards,

    Zoe Hui


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