question

DavidleQuesne-0877 avatar image
2 Votes"
DavidleQuesne-0877 asked KBarrett-1177 commented

SSIS 2019 unable to save script tasks

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
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@DavidleQuesne-0877,

Please add a screen shot with the error in VS2019 to your question.

2 Votes 2 ·
Monalv-msft avatar image
1 Vote"
Monalv-msft answered

Hi @DavidleQuesne-0877 ,

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.





5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

DavidleQuesne-0877 avatar image
1 Vote"
DavidleQuesne-0877 answered

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



install.png (109.0 KiB)
extension.png (51.3 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

DavidleQuesne-0877 avatar image
1 Vote"
DavidleQuesne-0877 answered DavidleQuesne-0877 edited

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


image.png (41.0 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

DavidleQuesne-0877 avatar image
1 Vote"
DavidleQuesne-0877 answered DavidleQuesne-0877 edited

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

85852-error2.png
85715-error1.png



error1.png (78.2 KiB)
error2.png (25.0 KiB)
error1.png (8.4 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

DavidleQuesne-0877 avatar image
1 Vote"
DavidleQuesne-0877 answered

Just tried running an installation repair using Visual Studio 2019 installer but this has no effect

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

YitzhakKhabinsky-0887 avatar image
1 Vote"
YitzhakKhabinsky-0887 answered DavidleQuesne-0877 commented

@DavidleQuesne-0877,

Please make sure that you have the following installed:

  • VS2019 v.16.9.3

  • SQL Server Integration Services Projects v.3.12.1

I don't have a bin directory on my machine under
c:\Program Files (x86)\Microsoft Visual Studio\2019\Professional\Common7\IDE\
and everything is working properly.

Please make sure that SSIS Script Task is using .Net Framework version that is installed on your machine.

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi

I checked registry and it is running above 4.5 (according to Microsoft Docs)
86811-image.png


1 Vote 1 ·
image.png (41.3 KiB)

86737-image.png



Specifically version 4.8

1 Vote 1 ·
image.png (5.6 KiB)
DavidleQuesne-0877 avatar image
1 Vote"
DavidleQuesne-0877 answered PiquetDWS-1738 commented

Hi

As you can see from the previous posts I am running all the latest and correct versions of Visual Studio and the SSIS projects extension. I am also running .net 4.8 on that VM.

The script task will be using whatever is appropriate for SQL Server 2016 (VSTA VB.net 2015 I believe.) This VM was running SSIS in VS17 perfectly until I upgraded it.

Obviously despite the patch to the SSIS Projects extension Microsoft still haven't got it right for systems that are only using SSIS. I'll wait for them to fix it for now

86814-image.png

David



image.png (8.1 KiB)
· 5
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Same issue here, all components are up to date

2 Votes 2 ·

Same issue here (i.e. missing bin folder) with VS2019 Community version 16.9.4, Integration Services Designer extension 15.0.2000.166 - an existing SSIS 2017 project being upgraded to SSIS 2019..

0 Votes 0 ·

Same issue. Professional version will work fine, but Community version won't compile scripts.

0 Votes 0 ·

It doesn't work with the professional version, that's what we're using.

0 Votes 0 ·

Hmmm. I' m using the Enterprise version as we are licenced for that under the partnership program.

I have a feeling it might be a mismatch between the library locations and the environment path settings.

0 Votes 0 ·
MOM-0461 avatar image
1 Vote"
MOM-0461 answered

Hi all.

I have the same proble.

I have SSIS package from VS 2017 Community version and all script task work fine, but in the same machine with a VS 2019 Professional when I try change and after rebuilt any script task I get this error:

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\Professional\Common7\IDE\bin'.

89084-image.png


I have reviewed the NetFramework version and seems that is correct for a 4.5 :

89064-image.png


I have try to change dt TargetFramework used for all script to 4.5 version,

(that is a suggestion in other forum)


after I realized that some packages with this version in script task work, and the packages that doesn't work have 4.0 version, but It doesn't work either.


Does anyone have any more ideas to solve that situation?

Many thanks


image.png (4.8 KiB)
image.png (9.7 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AidanOrton-0246 avatar image
2 Votes"
AidanOrton-0246 answered KBarrett-1177 commented

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




· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Many Thanks AidanOrton-0246

Your suggestion works perfectly.

The problem is that It has to make in all scripts, It is not a SSIS project configuration solution, I have to do in all script one by one, but really solve my problem.

Best Regards.

0 Votes 0 ·

I have the same problem
Error Could not find a part of the path 'C:\Program Files (x86)\Microsoft Visual Studio\2019\Enterprise\Common7\IDE\bin'
File: mscorlib

This temporary workaround work for me too. Thanks @AidanOrton-0246 .

I still need to to this for every script task but it's working and I'm waiting for any updates to fix this issue.

This problem appears to me a few weeks ago when I updated VS2019 from 16.8 to 16.9.5 and the error was pointing to a temp folder and the same file mscorlib.
I did a suggestion in other post to update to the latest MS Integration Services Project (15.0.2000.166) and the problem was fixed.
A few days later the problem reappears now pointing to this location C:\Program Files (x86)\Microsoft Visual Studio\2019\Enterprise\Common7\IDE\bin'
Same file: mscorlib



0 Votes 0 ·

Thank you AidanOrton-0246 for posting this fix. The modified version of the fix worked for me.

I hope MS can move the answer to the top so users don't waste more time scrolling through the dialog.


0 Votes 0 ·
DavidLeQuesne-4868 avatar image
0 Votes"
DavidLeQuesne-4868 answered

Hi

tried this by changing the dtproj files manually and by editing the project using the Visual Studio interface. Tried both changing the entries to .\bin\ and deleting them and neither change worked. Still got the dialog telling me it couldn't compile the script although no errors reported or found when editing the script.

When is Microsoft going to fix this? They have already agreed that this is a regression bug in Visual Studio 2019 in the link AidanOrton posted.

We are just sticking with VS 2017 for now until they release a working version.

Regards

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.