How to check if SQL Server BIDS is installed

ssis bids
c.jack picture c.jack · May 24, 2013 · Viewed 20.4k times · Source

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

Jacob Dickinson picture Jacob Dickinson · Jan 17, 2015

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.)

Related questions

Using SSIS BIDS with Visual Studio 2012 / 2013

I want to use SSIS /BIDS project in Visual Studio 2012. I have both Visual Studio 2010 and Visual Studio 2012 installed along with Microsoft SQL Server 2012. VS 2010 was installed first followed by MS SQL 2012 which got me BIDS integrated with VS 2010. However …

Read More
Error: 0xC0202009 at Data Flow Task, OLE DB Destination [43]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E21

My source is a TXT Flat File Source, the Destination is of type OLE DB. (see image) I found a very basic tutorial on Code Project to create a package. I finished the steps but when debugging I get a …

Read More
How to access ssis package variables inside script component

How can I access variables inside my C# code which I've used in Data Flow -> Script Component - > My c# Script with my SSIS package? I have tried with which is also not working IDTSVariables100 varCollection = null; …

Read More