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 ·
Ciaran-3461 avatar image
0 Votes"
Ciaran-3461 answered Ciaran-3461 edited

I have exactly the same issue. I've updated to 16.9.4 and now I cannot compile SSIS Scripts. I downloaded and installed the most recent version from here...

https://marketplace.visualstudio.com/items?itemName=SSIS.SqlServerIntegrationServicesProjects

Which fixed a previous error about being unable to write to a folder in %temp% but it has introduced another with respect to the relative location of the bin directory.

I shall have to spend the rest of the day downgrading to a previous working version which I neglected to make a note of so this is not going to be fun.

Please fix this.

Edit: So after 4 or 5 hours de-installing and re-installing I've found out that apparently VS2019 16.8.5 with SQL Server Integration Services Project 3.11.1 extension works. Fortunately I have a copy of SSIS Project 3.11.1 lying around. I could not find anywhere to download previous versions of that from. You can get previous versions of VS2019 from here...

https://docs.microsoft.com/en-us/visualstudio/releases/2019/history#installing-an-earlier-release

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.