Share via

SSIS 2019 unable to save script tasks

David le Quesne 46 Reputation points
2021-04-08T07:36:07.79+00:00

Hi

I have Visual Studio 2019 16.9.3 installed with just the Data storage and processing Toolset and the SQL Server Integration Services Project 3.12.1 extension.

When I try and compile a script task I get the following error from mscorlib.

Severity Code Description Project File Line Suppression State
Error Could not find a part of the path 'C:\Program Files (x86)\Microsoft Visual Studio\2019\Enterprise\Common7\IDE\bin'

Not surprising since this folder does not exist in the installation.

Obviously our migration to VS19 from VS17 is on hold until this issue can be resolved

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,703 questions

11 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Aidan Orton 11 Reputation points
    2021-05-06T07:14:47.44+00:00

    I was still having this issue, even with version 3.13.1 of the SSIS extension, so I posted the question on marketplace (here) and got this temporary workaround:

    1. Click “Edit Script” to open VS
    2. Right click on the project, and click “Open Folder in File Explorer”
    3. Open the proj file in some text editor
    4. Modify two “<OutputPath>bin\</OutputPath>” elements to “<OutputPath>.\bin\</OutputPath>”, or simply delete the two OutputPath elements
    5. Save the proj file, and now you can try to rebuild the project in VS.

    Works for me, deleting the 2 OutputPaths was easiest.

    Aidan

    2 people found this answer helpful.
  2. Monalv-MSFT 5,926 Reputation points
    2021-04-08T08:27:43.653+00:00

    Hi @David le Quesne ,

    1.Please check the version of Visual Studio 2019 that you download.
    85609-downloadvisualstudio2019.png
    85670-community.png

    2.Please check if you set TargetServerVersion as SQL Server 2019 in ssis project.

    Best regards,
    Mona

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

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    1 person found this answer helpful.
    0 comments
  3. David le Quesne 46 Reputation points
    2021-04-08T09:09:30.147+00:00

    Hi

    I am using the latest Visual Studio 2019 16.9.3 with the Data Storage and Processing Toolset installed.85742-install.png

    I have the SSIS Project extension 3.12.1 installed 85751-extension.png

    My target build is SQL Server 2016

    It appears this combination is missing the Common7\IDE\bin folder

    1 person found this answer helpful.
    0 comments
  4. David le Quesne 46 Reputation points
    2021-04-08T09:10:57.1+00:00

    Note that it is just the \bin folder that is missing. There are no issues reported in the script, SSIS just cannot find all the components it needs to compile it

    85707-image.png

    If it is mscorlib.dll it is looking for then there are several copies of that scattered around the installation, but not on that path

    1 person found this answer helpful.
    0 comments
  5. David le Quesne 46 Reputation points
    2021-04-08T13:59:21.373+00:00

    The screen shot of the errors. This script will compile and save correctly in VS17

    85852-error2.png
    85715-error1.png

    1 person found this answer helpful.
    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.