I have windows 8, and have installed VS2012 Developer.. I have installed everything with 2 instances one for multidimensional and one for tabular analysis.. In SQL I can find and open the SSAS..

I have VS 2012 installed.. From what I see I should have created another VS for 2010 because this is what SQL 2012 uses.. But.. I didn't get it.. And I did a search for the program in case it didn't get on the desktop, but only see SQL 2012 installed.. I looked in 2012, but I don't see any thing for SSIS or SSAS in it.. (I have in the past used Bids in SQL 2005 and SQL 2010 on other computers, so I think I would find it if it was there)..

I thought I saw something that said there was something I could download and install that had renamed BIDS to SSDT and would now install in the VS2012.. But installing it, it seemed to only be installing a SQL express, and my VS2012 showed no extra features for SSIS or SSAS after the install (Nor did I see a seprate VS2010 with SSIS & SSAS)..

Sorry I thought you have an issue with SQL Server Developer Edition itself and just reading over your question again I noticed you ask about BIDS as well - hope this is the right answer to your BIDS question.

There's also the SSDT which is the "BIDS" replacement for developing SSIS, SSRS and SSAS stuff. As of March 2013, it is now available for the 2012 release of Visual Studio. The download is labeled SSDTBI_VS2012_X86.msi Download link (below) is "Microsoft SQL Server Data Tools Business Intelligence for Visual Studio 2012"

Yes, that's what I thought.. On other computer systems I have Had the Bids of a different version then the Visual Studio version I was on, and I just ended up with 2 versions of VS on my desktop.. But not here..

I also read about the change of the BIDS to SSDT and that that was for VS2012.. I tried to download it.. But, I downloaded something called SSDTSetup.exe and it seemed to only be installing a SQL Express.. But after trying to install that, that is when I tried looking for something under the VS2012..

I tried the SSDTBI_VS2012_X86.msi..

I got this error..

The CPU architecture of installing feature(s) is different than the instance specified. To continue, add features to this instance with the same architecture.

I will look around for the error.. I have a feeling it might be the fact that it is x86 and I am on x64, But I didn't see a choice of an x64..

I got it to work.. I figured out the error hinted at a previous bad installation, and as I said, I had tried to run it before through SSDTSetup.exe.. So luckily I had created a restore point before that installation and I did a restore.. Then SSDTBI_VS2012_X86.msi was successfully installed..

BUT....

NOTHING I CAN SEE.. (see attached photo)

I know with the older SQL when it was called BIDS the SSAS & SSIS projects was under a folder Buisness Intelligence Projects.. I figure since it is now SSDT not BIdS I will see something SSDT-ish.. But... I see nothing..

Depending on which Microsoft employee (or, in some cases, which product installer) you want to believe, SSDT can be described in either of the following two ways:
• SSDT is a Visual Studio shell to enable development of solutions that include SQL Server databases, SQL Server Integration Services, SQL Server Analysis Services, and/or SQL Server Reporting Services.
• SSDT is a collection of features that aid in the development of SQL Server databases.

I don't know which one of those is the correct description; regardless, in this article I will discuss SSDT from the second of these two perspectives: as a collection of features that aid in the development of SQL Server databases

So looking at the video I DO have #2.. But, I find being able to create a tables in Visual Studio, not all that helpful since I can create tables in SQL Server.. Question still remains, where are the SSAS & SSIS tools???..!!!!

OK.. I got the VS2010 version to work.. Maybe it was there before.. Don't know.. I found a standalone for the VS2010 SSDT.. I ran it, it installed fine and I could see it in the Add remove programs.. But not on the desktop.. And when I did a search for visual studio programs still only showed VS 2012..

But.. Then I figured out how to look at the installed programs similar to what the start button would show you pre-Windows8.. And I found VS2010 there, and was able to move it onto my desktop.. When opened it has the SSIS & SSAS in it..

Yeah!!! Whether it is VS2010 or VS2012.. I care not.. It was just a serious problem not to have it at all.. Looking forward to getting a fix for this Windows8 and getting the start button back..

I am accepting the solution for SSDT 2012 from some other person and giving him all the points as a thank-you for the help, and it will most likely help other people.. Just something caused it not to work for me..

I gave myself best solution (but with no points).. Because I did get the SSDT 2010 to work by what I did.. But, I am unsure if my solution is the best for everyone.. It would be better if people got the newer version to work rather then the older one.

0

Featured Post

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.

Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables.
Make a table:
Update a specific column given a specific row using the UPDATE statement:
Remove a set of values using the DELETE s…