How to check if SQL Server BIDS is installed

Question

i want to create sql server integration service package by the use of Business Intelligence Development Studio but don't know why this studio is not getting open from sql server group, only command window gets open and suddenly closed, whether BIDS is installed or not how to check it, please help me for the same. thanks

Answer 1

I can install applications, but do not have the SQL Server installer package. To run it, I'd have to log a trouble ticket and wait for support help. In these circumstances, the approach that worked best was:

1. Open Visual Studio (2012, in my case).
2. Select the File menu New Project... option. This opens the New Project dialog.
3. If necessary, expand the Installed item in the left hand column.
4. Likewise, expand Templates.

If you see Business Intelligence listed here, you're probably in good shape. More specifically, after BIDS installation, my Visual Studio installation lists business intelligence template subcategories:

• Analysis Services
• Integration Services
• Reporting Services

(This is where my screen shot belongs, but I don't have the reputation points required to post it yet! Maybe later, if fate is kind.)

If you don't see this, download the Microsoft SQL Server Data Tools Business Intelligence project template installer and run it. (The link is to the Visual Studio 2012 English version, so you may need to search for the corresponding version.)