SSIS solution edited on VS 2019 Enterprise can't be opened on VS 2019 Pro

AntoDN 1 Reputation point
2020-08-27T15:25:18.537+00:00

I've had to switch from VS 2019 Enterprise to VS 2019 Pro as the Enterprise eval licence expired. (I had to install a separate instence of VS 2019 Pro). The SSIS solution and packages that worked fine on the Enterprise version won't open in the Pro version, (with the SSIS projects installed).

I can create a new SSIS project, and add existing packages, but the script tasks won't build, along with a string of other errors.

What's different between the two versions that might cause this, or are there other components that I need to install?

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
1,856 questions
Visual Studio Setup
Visual Studio Setup
Visual Studio: A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.Setup: The procedures involved in preparing a software program or application to operate within a computer or mobile device.
701 questions
No comments
{count} votes

3 answers

Sort by: Most helpful
  1. Yitzhak Khabinsky 20,011 Reputation points
    2020-08-27T15:40:44.213+00:00

    I think you need to reinstall SQL Server Integration Services Projects
    Upon its installation it is asking what VS2019 to use.
    So you would need to specify your VS2019 Pro edition.


  2. Monalv-MSFT 5,686 Reputation points
    2020-08-28T03:11:01.933+00:00

    Hi AntoDN,

    Could you please share the error messages when building the script tasks?

    Best Regards,
    Mona


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


  3. Monalv-MSFT 5,686 Reputation points
    2020-08-31T07:05:55.673+00:00

    Hi AntoDN,

    It seems that the script should be used in Script Component in Data Flow Task.

    But you used the script in the Script Task in Control Flow.

    Please refer to Comparing the Script Task and the Script Component to know the differences between Script Task and Script Component.

    Best Regards,
    Mona

    ----------

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