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.
SSIS solution edited on VS 2019 Enterprise can't be opened on VS 2019 Pro
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?
3 answers
Sort by: Most helpful
-
Yitzhak Khabinsky 25,721 Reputation points
2020-08-27T15:40:44.213+00:00 -
Monalv-MSFT 5,896 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.
-
Monalv-MSFT 5,896 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.