VS Professional 2017 - repair installation: The dependent package of 'Microsoft.VisualStudio.Product.Professional,version=15.9.28307.423' cannot be fo

[sph1777]

I have VS 2017 Professional Edition already installed in my machine.

I mainly use the SQL Server Data Tools (SSDT), work in SSIS and SSRS.

On top of this VS 2017, I have also installed VS 2010 (SSDT 2012), as a part of SQL Server 2012.

My development is mainly in VS 2017.

I have two problems:

1) In SSRS, when I run a simple table report, I find a weird behavior:

Clm1 Clm2 Clm 3 Clm 4

x

x x x x

x x x x

x x

x x x x

x

x

x x x x


Even though data is present in the database for every column, I see blank values.

'x' denotes data.

When I expand the column width of some of the four columns above, I see this:

Clm1 Clm2 Clm 3 Clm 4

x

x

x

x

x

x



I see data only in column 4 !

2) In SSIS, I have a problem with the Script Task:

The Edit Script is NOT opening in the Script Task of the SSIS Control Flow.




I am not sure whether the problems in VS 2017 is because of the VS 2010 installed.

When I try to repair the installation of VS Professional 2017, I see the following:

Sorry, something went wrong

The dependent package of 'Microsoft.VisualStudio.Product.Professional,version=15.9.28307.423' cannot be found: Component.Microsoft.VisualStudio.Tools.Applications,version=15.0.27520.3.



Can you help me sort the issues in SSRS, SSIS, and/or the repair the installation of VS Professional 2017 ?

Any suggestion please ?

Continue reading...