Visual Studio 2017 installation problems

This short post shows the issues many countries will face while installing Visual Studio 2017

Today, if you download the offline installation files for Visual Studio 15.7 is 42.8 GB
as compare to 23.3 GB for Visual Studio 2017 15.0.0.

Many countries have Internet access less the 1MB/second, and the line is inconsistent. That is the reason people try to get ISO. But today ISO is no longer available for Visual Studio 2017. To install via streaming many installation will fail.

I am not sure how many people can still download the 15.0 layout. At least, what I did was, I installed 15.0 then upgrade to 15.7. Even that will cost me 3.63GB with only around 6 workloads not all the workloads. Open eyes and see clearly. I only get 748 KB/sec. That took me hours to upgrade.

Visual Studio team should look into how to make developers life better. Android Studio is nothing better but it can at least install the base less than 2GB.

Posted in .Net, Cloud, Community, Computers and Internet, Servers | Tagged , , | Leave a comment

Free ebook Azure Quick Start Guide for .NET Developers

This is a nice ebook for you to know most of the key services in Azure. This is not the book that will give you a complete running samples.

It provides high overview but leave with many arguable such as in Table 3. Store large data in SQL Data Warehouse is tick but not Database. To most of the .NET developers SQL Data Warehouse is just another SQL Database with different table structure design.

The direct download link for Azure Quick Start Guide for .NET Developers is here:


Posted in .Net, Cloud, Community, Computers and Internet | Tagged , , , , , | Leave a comment

VSTS Iterations not appear in Work

This blog shows you how to add iteration to your Work area.

Let’s say you have Sprint up to 22. Somehow when you click on Work in your VSTS you only see up to Sprint 20.

Click on the Gear. Click on the Iterations. Click on + Select iteration(s).

Posted in .Net, Cloud, Community, Computers and Internet | Tagged , , | Leave a comment

SSIS The connection “” is not found

This blog shows you how to get the SSIS component that generates the error such as “The connection “{6A2BEE57-1779-4B4F-9573-116F568F928F}” is not found” in your SSIS package.

When you open your SSIS Package dtsx, you might see the dialog below pop up.

When I looked at the error I got the one below:

“Severity    Code    Description    Project    File    Line    Suppression State

Error        Error loading FileLoopETD.dtsx: The connection “{6A2BEE57-1779-4B4F-9573-116F568F928F}” is not found. This error is thrown by Connections collection when the specific connection element is not found.        D:\SSIS\chanmm\dev2\ssisLab\ssisLab\FileLoopETD.dtsx    1″

There is no way for find out from the dtsx Designer fast. You need to click on the components with connection one by one. In order to find this fast right click the dtsx with error and choose View Code.

For me, according to my error I should search for “6A2BEE57-1779-4B4F-9573-116F568F928F”. From here I know the error is with an Execute SQL Task component named Create and Truncate Staging table.

Locate the Execute SQL Task component called Create or Truncate Staging table double click to open it.

So the Connection property is causing the error. You need to choose a valid connection.

Posted in .Net, Cloud, Community, Computers and Internet | Tagged | Leave a comment

Skype for Business App no audio

When you browse to Skype for Business meeting using Chrome, and it will prompt you the following screen to start Skype for Business App.

In some cases, your meeting start without audio after it has started.

This what you need to do.

Right click on the speaker at your taskbar. Choose Sounds.

Go to the Playback tab to configure your audio device. You must have the green tick at your audio device in order to have sound for your Skype for Business App.

You should have 2 Skype Meeting App in your Volume Mixer.

Posted in Cloud, Community, Computers and Internet, Office 365 | Tagged , , , | Leave a comment

Microsoft.SqlServer.Dts.Runtime missing

This short blog just to show you where can you get the Microsoft.SqlServer.Dts.Runtime namespace.

There is no such thing as Microsoft.SqlServer.Dts.Runtime.dll

The namespace is in Microsoft.SQLServer.ManagedDTS.dll.

My one is located at:

C:\Program Files (x86)\Microsoft SQL Server\120\SDK\Assemblies\ Microsoft.SQLServer.ManagedDTS.dll

Posted in .Net, Cloud, Community, Computers and Internet | Tagged , , | Leave a comment

JavaScript runtime error: ‘Excel’ is undefined

This blog shows you the cause of the error “JavaScript runtime error: ‘Excel’ is undefined”. There is a solution but might not resolving your problem.

When I run my Add-ins in Office 2013 Excel then I got the error “JavaScript runtime error: ‘Excel’ is undefined”.

I run the same code in Office 365 Excel then turn out to be fine.

Below is exactly the same code I am running for both Excel versions. (ctx) {

    // Create a proxy object for the active sheet

    var sheet = ctx.workbook.worksheets.getActiveWorksheet();

    // Queue a command to write the sample data to the worksheet

    sheet.getRange(“B3:D5”).values = values;

    // Run the queued-up commands, and return a promise to indicate task completion

    return ctx.sync();



I hope Microsoft can make the Excel object supported by Office 2013. My reason of cannot upgrade to Office 365 is because the organization is still yet to move away from Microsoft Exchange 2007. Somehow Office 365 cannot support Exchange 2007. I do hope Microsoft can have better backward compatibilities.

Posted in .Net, Cloud, Community, Computers and Internet, Office 365, sharepoint | Tagged , , | Leave a comment