Why "Azure" related tools are grey out in SSIS after installation of Azure feature pack?

Problem: After installation of Azure feature pack for SSIS, Azure related toolboxes are still grey out?

Solution: 

If Azure related toolboxes are grey out in SSIS, that means that the version of SQL server is different from the version of Azure feature pack. You need to change the TargetServerVersion in visual studio to the same version of Azure feature pack you installed.

For example, if you download and install Microsoft SQL Server 2016 Integration Services Feature Pack for Azure for SQL Server 2016, you need to set TargetServerVersion in visual studio to be SQL Server 2016 as shown below:

Now your project version will show: SQL Server 2016 and Azure related tools will show up in your SSIS toolbox!

Why PowerPivot add-in is missing from some Office 365 plan?

When you follow the steps in my previous post "How to: Enable PowerPivot Add-ins for Excel 2013" to add PowerPivot in excel with Office 365, you may not be able to find PowerPivot in available COM add-ins.

You may wonder whether you missed any steps? That may not be the case. From "Feature availability across Office 365 plans", you will know PowerPivot feature is only available for the following Office 365 Plans (as of 11/2017):

• Office Professional Plus 2013         
• Office Professional Plus 2016
• Office 365 ProPlus                     
• Office 365 Business
• Office 365 Business Premium
• Office 365 Enterprise E3

So go ahead to check your Office 365 Plan first. If it is not available, the alternative is to use Power BI Desktop, the tool for desktop data analytics. Good luck!

How to: Show Line Number in SQL Server Management Studio

Have you ever met the following scenarios: 1) when you write a very complex ad-hoc query in SQL Server Management Studio (SSMS), you need to count the total columns that have been derived. 2) You even need to refer to the line that appears in the error message. If yes, you need to enable the option of showing line numbers in SSMS. In fact it is very simple. It can be done in a minute. You just need to know to click the right button. Be cautious that it is different for SQL Server 2008 (2008R2) and SQL Server 2012.

Solution

Step 1: In SSMS, select Tools tab then Options as shown below

Step 2: In Option Popup Windows, expand “Text Editor”

a. For SQL Server 2008 and SQL Server 2008R2, you need to choose “All Languages”. Under General page, check the box for Line Number.

b. For SQL Server 2012, you need to choose “Transact-SQL”. Under General page, check the box for Line Number.

Hope this tip will help you improve your coding efficiency. If you just want to jump to some specific line in SSMS quickly, you can use CTRL+G hot key.